Dynamic where clause (OR) in Linq to Entities

by

With LINQKit’s PredicateBuilder you can build predicates dynamically.

var query = from u in context.Users select u;
var pred = Predicate.False<User>();

if (type.HasFlag(IdentifierType.Username))
    pred = pred.Or(u => u.Username == identifier);

if (type.HasFlag(IdentifierType.Windows))
    pred = pred.Or((u => u.WindowsUsername == identifier);

return query.Where(pred.Expand()).FirstOrDefault();
// or return query.AsExpandable().Where(pred).FirstOrDefault();

This is what the Expand is for:

Entity Framework’s query processing pipeline cannot handle invocation expressions, which is why you need to call AsExpandable on the first object in the query. By calling AsExpandable, you activate LINQKit’s expression visitor class which substitutes invocation expressions with simpler constructs that Entity Framework can understand.

Or: without it an expression is Invoked, which causes an exception in EF:

The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities.

Later addition:

There is an alternative predicate builder that does the same but without Expand: http://petemontgomery.wordpress.com/2011/02/10/a-universal-predicatebuilder/

More Related Contents:

  1. How to create LINQ Expression Tree to select an anonymous type
  2. ‘Contains()’ workaround using Linq to Entities?
  3. “A lambda expression with a statement body cannot be converted to an expression tree”
  4. Bulk-deleting in LINQ to Entities
  5. The type of one of the expressions in the join clause is incorrect in Entity Framework
  6. Entity framework left join
  7. LEFT JOIN in LINQ to entities?
  8. How to compare only date components from DateTime in EF?
  9. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  10. Linq to Entity Join table with multiple OR conditions
  11. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  12. Dynamic query with OR conditions in Entity Framework
  13. Calling a SQL User-defined function in a LINQ query
  14. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  15. Method cannot be translated into a store expression
  16. How to use a string to create a EF order by expression?
  17. Establish a link between two lists in linq to entities where clause
  18. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  19. How to group by on 2 child entities and get total of both this child entities?
  20. Dynamic table name in linq [duplicate]
  21. How do I perform Date Comparison in EF query?
  22. Join and Include in Entity Framework
  23. Filtering include items in LINQ and Entity Framework [duplicate]
  24. How to get first record in each group using Linq
  25. Creating dynamic queries with entity framework
  26. String.IsNullOrWhiteSpace in LINQ Expression
  27. The LINQ expression could not be translated and will be evaluated locally
  28. Update records using LINQ
  29. How to group by DateTime.Date in EntityFramework
  30. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()

Leave a Comment