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
  • 700 Content
  • 209 Contributors

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

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

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

Help with EF Core / Lambda/ LinQ

4

Using EF Core 5


How would I create the Linq or ef statement to do the following SQL statement.


I would

Troubleshooting Solution

Linq query to get a list of roles for a user in identity framework using blazor c#

3

using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Identity;

I want to get a list

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 syntax error

bylulu50
11
Hi,

all I want to do is select FromDate value and store it in the FromDate parameter.

I can't fix my …
Troubleshooting Solution

c# Linq statement returning wrong values

6
I have the following code segement.  This is LINQ.   The linq query pulls an a list of items from …
Troubleshooting Solution

Need help with Link Query for left outer join

1
Hi Experts,
This is my LINQ query. Now my query is doing a inner join with _adhocInvoiceToRcid table. …
Troubleshooting Solution

Adding if then structure to LINQ vb.net code

1
Hi.
How do I add conditional commands (if then structure) to a chain of LINQ vb.net code?

[Sample if
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

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)

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

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

4
Hi Experts!

Have a User class that implements IComparable<User>. What this gives us is the …
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 …
Troubleshooting Solution

retrieving last record grouped by multiple columns via Linq

8
Hello all:

I am using Linq to query a table and want to get the last record grouped by several …
Troubleshooting Solution

Ignore milliseconds when comparing two datetimes in LINQ

2
I have this LINQ query code (see below) that keeps throwing the error "LINQ to Entities does not …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more