.NET LINQ query syntax vs method chain

by

No, because they are compiled into exactly the same code.

Basically query expressions are “pre-processed” by the compiler into “C# 3 without query expressions” and then the rules of overloading, lambda expression translation etc are applied as normal. It’s a really elegant system which means that the rules for query expressions are limited to just one small bit of the spec.

Of course, there are various things you can write in “chained method” syntax which can’t be written in query expression syntax, either due to using other overloads or the methods simply not being supported (e.g. Count()) – but unless you’re using those, the compiled code will be exactly the same. Pick the most readable alternative for any particular scenario.

More Related Contents:

  1. Which method performs better: .Any() vs .Count() > 0?
  2. Is it better to call ToList() or ToArray() in LINQ queries?
  3. Why is LINQ JOIN so much faster than linking with WHERE?
  4. LINQ to Entities does not recognize the method
  5. What is the difference between IQueryable and IEnumerable?
  6. How to do SQL Like % in Linq?
  7. Why are multi-dimensional arrays in .NET slower than normal arrays?
  8. Performance of Arrays vs. Lists
  9. What’s so wrong about using GC.Collect()?
  10. Case insensitive string compare in LINQ-to-SQL
  11. “Or” equivalent in Linq Where() lambda expression
  12. How do I get the MAX row with a GROUP BY in LINQ query?
  13. LINQ: Not Any vs All Don’t
  14. LINQ Single vs First
  15. Linq int to string
  16. EF LINQ include multiple and nested entities
  17. Why seal a class?
  18. Why is LINQ .Where(predicate).First() faster than .First(predicate)?
  19. Can you get a Func (or similar) from a MethodInfo object?
  20. Does LINQ work with IEnumerable?
  21. How to use “contains” or “like” in a dynamic linq query?
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. Why does IQueryable.All() return true on an empty collection?
  24. System.IO.FileSystemWatcher to monitor a network-server folder – Performance considerations
  25. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  26. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  27. Does .NET assembly size affect performance?
  28. Linq: What is the difference between Select and Where
  29. Entity Framework Find vs. Where
  30. How to Convert Row to Column in Linq and SQL

Leave a Comment