How to dynamically add OR operator to WHERE clause in LINQ

by

You can use the PredicateBuilder class:

var searchPredicate = PredicateBuilder.False<Songs>();

foreach(string str in strArray)
{
   var closureVariable = str; // See the link below for the reason
   searchPredicate = 
     searchPredicate.Or(SongsVar => SongsVar.Tags.Contains(closureVariable));
}

var allSongMatches = db.Songs.Where(searchPredicate);

LinqToSql strange behaviour

More Related Contents:

  1. Linq To Sql – Dynamic OrderBy – Case When
  2. LINQ-to-SQL vs stored procedures? [closed]
  3. Linq: adding conditions to the where clause conditionally
  4. LINQ Between Operator
  5. LINQ across multiple databases
  6. Learning about LINQ [closed]
  7. How can I reject all changes in a Linq to SQL’s DataContext?
  8. LINQ with SQLite (linqtosql)
  9. How to create a dynamic LINQ join extension method
  10. LINQ not updating on .SubmitChanges()
  11. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  12. Is there a pattern using Linq to dynamically create a filter?
  13. How to use “contains” or “like” in a dynamic linq query?
  14. Linq to SQL how to do “where [column] in (list of values)”
  15. Multiple WHERE clause in Linq
  16. How do I write this cross apply query in LINQ-to-SQL?
  17. Point connectionstring in dbml to app.config
  18. Building Dynamic LINQ Queries based on Combobox Value
  19. NHibernate vs LINQ to SQL
  20. Difference Between Select and SelectMany
  21. What are the benefits of a Deferred Execution in LINQ?
  22. LINQ recursion function?
  23. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  24. LINQ: Dot Notation vs Query Expression
  25. Convert Linq Query Result to Dictionary
  26. Simple Linq query has duplicated join against same table?
  27. LINQ Include vs Join. Are they equivalent?
  28. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  29. If condition in LINQ Where clause
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment