Fluent and Query Expression — Is there any benefit(s) of one over other?

by

Neither is better: they serve different needs. Query syntax comes into its own when you want to leverage multiple range variables. This happens in three situations:

  • When using the let keyword
  • When you have multiple generators (from clauses)
  • When doing joins

Here’s an example (from the LINQPad samples):

string[] fullNames = { "Anne Williams", "John Fred Smith", "Sue Green" };

var query =
  from fullName in fullNames
  from name in fullName.Split()
  orderby fullName, name
  select name + " came from " + fullName;

Now compare this to the same thing in method syntax:

var query = fullNames
  .SelectMany (fName => fName.Split().Select (name => new { name, fName } ))
  .OrderBy (x => x.fName)
  .ThenBy  (x => x.name)
  .Select  (x => x.name + " came from " + x.fName);

Method syntax, on the other hand, exposes the full gamut of query operators and is more concise with simple queries. You can get the best of both worlds by mixing query and method syntax. This is often done in LINQ to SQL queries:

var query =
  from c in db.Customers
  let totalSpend = c.Purchases.Sum (p => p.Price)    // Method syntax here
  where totalSpend > 1000
  from p in c.Purchases
  select new { p.Description, totalSpend, c.Address.State };

More Related Contents:

  1. Prevent duplicates from array, based on condition [closed]
  2. Where is likely the performance bug here? [closed]
  3. Combining two expressions (Expression)
  4. LINQ : Dynamic select
  5. Dynamic where clause (OR) in Linq to Entities
  6. Paging with LINQ for objects
  7. Pivot data using LINQ
  8. Using Linq to get the last N elements of a collection?
  9. Optimal LINQ query to get a random sub collection – Shuffle
  10. Searching a tree using LINQ
  11. How can I get LINQ to return the object which has the max value for a given property? [duplicate]
  12. Recursive Hierarchy – Recursive Query using Linq
  13. Filter/Search using Multiple Fields – ASP.NET MVC
  14. Operation could destabilize the runtime?
  15. How to select only the records with the highest date in LINQ
  16. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  17. C# Linq intersect/except with one part of object
  18. Entity-framework code is slow when using Include() many times
  19. Linq to Objects – return pairs of numbers from list of numbers
  20. From Eric Lippert’s blog: “don’t close over the loop variable” [duplicate]
  21. Export Model to DataTable
  22. loading a full hierarchy from a self referencing table with EntityFramework.Core
  23. Update XML with C# using Linq
  24. Add the where clause dynamically in Entity Framework
  25. Split a List into groups of consecutive numbers [closed]
  26. How to set property value using Expressions? [duplicate]
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Transform IEnumerable asynchronously by awaiting each task
  29. How to check if all list items have the same value and return it, or return an “otherValue” if they don’t?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment