Add the where clause dynamically in Entity Framework

by

You can use a beautiful thing called PredicateBuilder. Use it like this

var pr = PredicateBuilder.False<User>();
foreach (var name in names)
{
    pr = pr.Or(x => x.Name == name && x.Username == name);
}
return query.AsExpandable().Where(pr);

More Related Contents:

  1. Entity Framework/Linq EXpression converting from string to int
  2. LEFT JOIN in LINQ to entities?
  3. The result of a query cannot be enumerated more than once
  4. Creating dynamic queries with entity framework
  5. String.Equals() not working as intended
  6. LINQ to Entities group-by failure using .date
  7. How to write this nested foreach loop query in LINQ?
  8. Group by in LINQ
  9. There is already an open DataReader associated with this Command which must be closed first
  10. Reading a file line by line in C#
  11. ToList()– does it create a new list?
  12. Combination of List
  13. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  14. How to use the IEqualityComparer
  15. Check if two lists are equal
  16. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  17. LINQ aggregate and group by periods of time
  18. VB.NET equivalent to C# var keyword [duplicate]
  19. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  20. How set value a property selector Expression
  21. LINQ: Using INNER JOIN, Group and SUM
  22. linq distinct or group by multiple properties
  23. Filtering include items in LINQ and Entity Framework [duplicate]
  24. How to get duplicate items from a list using LINQ? [duplicate]
  25. Max or Default?
  26. How to check for nulls in a deep lambda expression? [duplicate]
  27. What does LINQ return when the results are empty
  28. LINQ performance FAQ
  29. linq: order by random
  30. Select distinct rows from datatable in Linq

Leave a Comment