“The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!

by

I was getting this very error and I’m using Entity Framework with PredicateBuilder by Joe Albahari to build dynamic where clauses. If you happen to be in the same condition, you should call the AsExpandable method:

If querying with Entity Framework, change the last line to this:

return objectContext.Products.AsExpandable().Where(predicate);

This method is part of LINQKIT DLL that you can grab here or through a NuGet package here.

Everything works fine now. 🙂

More 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. “A lambda expression with a statement body cannot be converted to an expression tree”
  5. Bulk-deleting in LINQ to Entities
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. LEFT JOIN in LINQ to entities?
  9. How to compare only date components from DateTime in EF?
  10. The result of a query cannot be enumerated more than once
  11. Linq to Entity Join table with multiple OR conditions
  12. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  13. Dynamic query with OR conditions in Entity Framework
  14. Calling a SQL User-defined function in a LINQ query
  15. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  16. Is there a good LINQ way to do a cartesian product?
  17. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  18. Entity Framework Timeouts
  19. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  20. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  21. Entity Framework/Linq EXpression converting from string to int
  22. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  23. The instance of entity type cannot be tracked because another instance of this type with the same key is already being tracked
  24. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  25. linq to entities doesn’t recognize a method
  26. How to convert an expression tree to a partial SQL query?
  27. How to get first record in each group using Linq
  28. String.IsNullOrWhiteSpace in LINQ Expression
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment