Explore LINQ on Experts Exchange

Expert Solutions for Your Tech Problems

LINQLINQ Query

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although po...

Read more
  • 726 Content
  • 215 Contributors

Leading Experts In
LINQ Query
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!

Troubleshooting Solution

Type arguments for method cannot be inferred. when ordering query using ToLower

4

Cannot figure out how to preface my orderby column with a ToLower(columnName). I get an error.


The

Troubleshooting Solution

How to type cast in MVC 4?

byakohan
61
This is the case I'm facing:

I do have 3 controllers as following: a) MetricController b) …
Troubleshooting Solution

C# Linq to Get XML

38
If I have the below XML.  I want to do 2 things.

First get everything between <key></key> so I …
Troubleshooting Solution

LINQ used for Searching database records.  - please help with join and refactoring for performance

27

Please assist with refactoring this LINQ method along with adding a join to it.


This method allow

Troubleshooting Solution

I need to use TWO parameters in this LINQ query. How?

3

This works, but I need a second parameter:


ssql.GetSynergyTable().AsEnumerable().Select(p =>

Troubleshooting Solution

Use Linq based on a list

byAlHal2
11

I have a linq clause like this


How would I get it working if I have a list of ShopCodes rather than …
Troubleshooting Solution

Help with modifying LINQ query

9
I need to filter this from the given table as its returning too many rows.   THis linq query is …
Troubleshooting Solution

LINQ - .net core 5.0 - Adding join and refactoring for complexity and performance

17

Please help to add a join to this LINQ statement along with any refactoring that would be writing

Research Solution

I need to sum each Int in a list, using LINQ

13

I need to sum each Int in a list, using LINQ


The Row has 4-columns, the last of which is called

Troubleshooting Solution

C# Delete values from LIst<string> verifying against Enum

19
I am writing an app that will get a list of directories and files.  I am populating a List<string> …
Troubleshooting Solution

Convert SQL with Joins, GroupBy and counts to Linq

byAlHal2
6

I’m trying to write a Linq statement starting off with SQL with which I’m more familiar.  I’ve

Troubleshooting Solution

Linq Data Range

bylulu50
21
Hi,

I need your help please!!!

 I want to say if the user enter in GroupTxt a range from 10 …
Troubleshooting Solution

SqlFunctions.DateAdd("yyyy", u.JoinedYear - 1900, 0)

byAllan
18
Hi Experts!

Have this sql that tells me the years the user being a member:
SELECT …
Troubleshooting Solution

LINQ Query returning a null value for a System.Decimal type.

22
Because there is no data available to sum, this code is producing a null value and throwing an …
Troubleshooting Solution

Getting multiple columns using LINQ

16
Hi,

I added a new employee to SQL table.
Add(3, "Issy", "Holm");
And I added this to the List.…
Troubleshooting Solution

I am having trouble with this simple LINQ query

8

I add a column to the table, set the column inside the function CullLotsForProduct(), and see the

Troubleshooting Solution

How do I use a column from a SQL table as an identifier in a LINQ Query?

22
I have a SQL table with columns that contain either "Required" or "Not Required."  I want to build a…
Troubleshooting Solution

List - Reverse Sort Not Working

byAllan
4
Hi Experts!

Have a User class that implements IComparable<User>. What this gives us is the …
Advice Solution

DataTable: I need a LINQ statement which returns as many rows as needed

9

I have a DataTable with an integer field, NUM_BOTTLES. I need to use Select(), or related call,

Troubleshooting Solution

VB.Net/LINQ: ".Contains" condition not finding existing result in MSSQL

16
Hi,
I have a Linq query that runs a search in 2 tables (through a "Join"):

First table is …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more