Linq: adding conditions to the where clause conditionally

by

If you do not call ToList() and your final mapping to the DTO type, you can add Where clauses as you go, and build the results at the end:

var query = from u in DataContext.Users
   where u.Division == strUserDiv 
   && u.Age > 18
   && u.Height > strHeightinFeet
   select u;

if (useAge)
   query = query.Where(u => u.Age > age);

if (useHeight)
   query = query.Where(u => u.Height > strHeightinFeet);

// Build the results at the end
var results = query.Select(u => new DTO_UserMaster
   {
     Prop1 = u.Name,
   }).ToList();

This will still only result in a single call to the database, which will be effectively just as efficient as writing the query in one pass.

More Related Contents:

  1. Entity Framework: There is already an open DataReader associated with this Command
  2. LINQ-to-SQL vs stored procedures? [closed]
  3. Entity framework linq query Include() multiple children entities
  4. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  5. Only initializers, entity members, and entity navigation properties are supported
  6. LINQ Between Operator
  7. LINQ across multiple databases
  8. Convert String to Int in EF 4.0
  9. Learning about LINQ [closed]
  10. How can I reject all changes in a Linq to SQL’s DataContext?
  11. LINQ with SQLite (linqtosql)
  12. Linq-to-entities – Include() method not loading
  13. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  14. How to create a dynamic LINQ join extension method
  15. Instantiating a context in LINQ to Entities
  16. conditional include in linq to entities?
  17. EF 4: Removing child object from collection does not delete it – why?
  18. Linq To Entities – how to filter on child entities
  19. How to dynamically add OR operator to WHERE clause in LINQ
  20. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  21. Linq To Sql – Dynamic OrderBy – Case When
  22. Is there a pattern using Linq to dynamically create a filter?
  23. LINQ OrderBy not ordering .. changing nothing .. why?
  24. Simple Linq query has duplicated join against same table?
  25. Linq to SQL how to do “where [column] in (list of values)”
  26. Multiple WHERE clause in Linq
  27. How do I write this cross apply query in LINQ-to-SQL?
  28. Point connectionstring in dbml to app.config
  29. Building Dynamic LINQ Queries based on Combobox Value
  30. NHibernate vs LINQ to SQL

Leave a Comment