Dynamic query with OR conditions in Entity Framework

You’re probably looking for something like Predicate Builder which allows you to control the AND’s and OR’s of the where statement easier.

There’s also Dynamic Linq which allows you to submit the WHERE clause like a SQL string and it will parse it into the correct predicate for a WHERE.

Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. ‘Contains()’ workaround using Linq to Entities?
  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. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  8. LEFT JOIN in LINQ to entities?
  9. “A lambda expression with a statement body cannot be converted to an expression tree”
  10. How to compare only date components from DateTime in EF?
  11. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  12. Linq to Entity Join table with multiple OR conditions
  13. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  14. Calling a SQL User-defined function in a LINQ query
  15. MSSQL Error ‘The underlying provider failed on Open’
  16. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  17. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  18. The cast to value type ‘Int32’ failed because the materialized value is null
  19. Getting data from stored procedure with Entity Framework
  20. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  21. Entity framework very slow to load for first time after every compilation
  22. How can I lock a table on read, using Entity Framework?
  23. Establish a link between two lists in linq to entities where clause
  24. Value cannot be null. Parameter name: source
  25. Linq to Entities, random order
  26. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  27. Creating dynamic queries with entity framework
  28. LINQ to SQL multiple tables left outer join
  29. How to use a string to create a EF order by expression?
  30. Entity Framework/Linq EXpression converting from string to int
  31. Filter/Search using Multiple Fields – ASP.NET MVC
  32. How to Bulk Update records in Entity Framework?
  33. linq to entities doesn’t recognize a method
  34. EF 6 – How to correctly perform parallel queries
  35. Entity Framework 6 Code First Custom Functions
  36. Order by dynamic parameter
  37. String.IsNullOrWhiteSpace in LINQ Expression
  38. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  39. Check if list contains item from other list in EntityFramework
  40. How to get next value of SQL Server sequence in Entity Framework?
  41. Join and Include in Entity Framework
  42. Optimistic concurrency: IsConcurrencyToken and RowVersion
  43. Export Model to DataTable
  44. Max return value if empty query
  45. Remove item from list based on condition
  46. Keyword Not Supported: Metadata
  47. Why is EF generating SQL queries with unnecessary null-checks?
  48. How to do an “in” query in entity framework?
  49. How to Specify Primary Key Name in EF-Code-First
  50. linq to entities vs linq to objects – are they the same?

Leave a Comment