“Or” equivalent in Linq Where() lambda expression

by

You can certainly do it within a Where clause (extension method). If you need to build a complex query dynamically, though, you can use a PredicateBuilder.

 var query = collection.Where( c => c.A == 1 || c.B == 2 );

Or using a PredicateBuilder

 var predicate = PredicateBuilder.False<Foo>();
 predicate = predicate.Or( f => f.A == 1 );
 if (allowB)
 {
    predicate = predicate.Or( f => f.B == 1 );
 }

 var query = collection.Where( predicate );

More Related Contents:

  1. Linq: What is the difference between Select and Where
  2. LINQ to Entities does not recognize the method
  3. Which method performs better: .Any() vs .Count() > 0?
  4. What is the difference between IQueryable and IEnumerable?
  5. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  6. Is it better to call ToList() or ToArray() in LINQ queries?
  7. LINQ to SQL Left Outer Join
  8. Why is LINQ JOIN so much faster than linking with WHERE?
  9. Linq to Entities – SQL “IN” clause
  10. LINQ on the .NET 2.0 Runtime
  11. Wrap a delegate in an IEqualityComparer
  12. How do I get the MAX row with a GROUP BY in LINQ query?
  13. LINQ Single vs First
  14. Why does a Linq Cast operation fail when I have an implicit cast defined?
  15. Linq int to string
  16. .NET List Concat vs AddRange
  17. Ignore namespaces in LINQ to XML
  18. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  19. Why use LINQ Join on a simple one-many relationship?
  20. Does LINQ work with IEnumerable?
  21. LINQ, can’t join to string
  22. How to use “contains” or “like” in a dynamic linq query?
  23. Why does IQueryable.All() return true on an empty collection?
  24. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  25. Why are some object properties UnaryExpression and others MemberExpression?
  26. How to perform merge sort using LINQ?
  27. Linq to Objects: does GroupBy preserve order of elements?
  28. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  29. How to Convert Row to Column in Linq and SQL
  30. How to return a page of results from SQL?

Leave a Comment