All 18 LINQ questions
More in LINQ
What is LINQ, and how does it simplify querying collections compared to writing manual loops? What is the difference between IEnumerable<T>, IQueryable<T>, and List<T>, and how does choosing the wrong one hurt performance against a database? How does GroupBy translate and what performance pitfalls exist? Why can LINQ cause the N+1 query problem and how do you fix it? How would you write a custom LINQ extension method that integrates seamlessly with the standard method-chaining style, like a 'DistinctBy' before it existed natively? How does LINQ's Aggregate() method work, and how would you use it to implement a custom reduction not covered by Sum()/Average()/Count()? How would you write an efficient LINQ query combining Join() with GroupBy() to replicate a SQL-style LEFT OUTER JOIN with aggregation? How would you optimize a LINQ-to-Entities query to avoid the classic 'N+1 query' performance problem when accessing related navigation properties?
Advertisement
C# › LINQ

How does LINQ to Objects differ fundamentally from LINQ to Entities (Entity Framework), particularly regarding how the query is actually executed?

Advanced

Answer

LINQ to Objects compiles queries into regular, DIRECTLY-EXECUTABLE C# delegates that run in-process against in-memory collections; LINQ to Entities (via IQueryable<T>) instead builds an EXPRESSION TREE representing the query's structure, which Entity Framework TRANSLATES into SQL and executes on the DATABASE SERVER — meaning not every C# expression/method is translatable, and some LINQ code that works fine against a List<T> throws at runtime against a DbSet<T>.
IEnumerable<User> inMemory = users.Where(u => u.IsActive); // runs entirely in C#, in-process

IQueryable<User> fromDb = dbContext.Users.Where(u => u.IsActive); // translated to SQL: WHERE IsActive = 1
// dbContext.Users.Where(u => SomeComplexCSharpOnlyMethod(u)); // may throw: can't translate to SQL
Real-world example Debugging a runtime error where a LINQ query worked fine in a unit test against an in-memory List<T> but failed against the real Entity Framework DbSet<T>.

Common follow-ups: Why does calling .ToList() or .AsEnumerable() partway through an EF Core query change what CAN be used in the REMAINING LINQ chain?

Fundamentals
All 18 LINQ questions