Start Debugging

linq

16 posts · Page 2 of 2

2026-08-23 ef-core linq csharp

How to write reusable LINQ predicates that EF Core can translate in Where, Select, and OrderBy

A bool helper method throws "could not be translated". An Expression<Func<T, bool>> does not. Here is how to compose, nest, and reuse expression trees in EF Core 11 without LINQKit, with the real SQL for every case.

2026-08-19 errors ef-core dotnet

Fix: "An exception was thrown while attempting to evaluate a LINQ query parameter expression" in EF Core 11

EF Core throws this when a client-evaluated piece of your query throws while EF evaluates it. Read InnerException, turn on EnableSensitiveDataLogging, and move the null check outside the lambda.

2026-07-21 errors csharp dotnet

Fix: System.InvalidOperationException: Sequence contains no elements

This exception means you called .First() or .Single() on an empty sequence. Use FirstOrDefault/SingleOrDefault and null-check, or guard the query, or fix why the source is empty.

2026-06-12 dotnet-11 csharp linq

LINQ Gets FullJoin and Selector-Free Joins in .NET 11 Preview 5

.NET 11 Preview 5 adds a brand-new FullJoin operator to LINQ plus tuple-returning overloads for Join, LeftJoin, RightJoin, and GroupJoin that drop the result selector entirely.

2026-05-21 comparison csharp linq

IEnumerable vs IAsyncEnumerable vs IQueryable in C#: which one should the method return?

Three sequence interfaces, three execution models. Use IQueryable when a database can translate the query, IAsyncEnumerable when the producer is async and you want to stream, IEnumerable for everything else in memory.

2026-04-20 dotnet-11 ef-core-11 sql-server

EF Core 11 translates Contains to JSON_CONTAINS on SQL Server 2025

EF Core 11 auto-translates LINQ Contains over JSON collections to the new SQL Server 2025 JSON_CONTAINS function, and adds EF.Functions.JsonContains for path-scoped and mode-specific queries that can hit a JSON index.