Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error

by

It looks like you’re trying to do the equivalent of a “WHERE…IN” condition. Check out How to write ‘WHERE IN’ style queries using LINQ to Entities for an example of how to do that type of query with LINQ to Entities.

Also, I think the error message is particularly unhelpful in this case because .Contains is not followed by parentheses, which causes the compiler to recognize the whole predicate as a lambda expression.

More Related Contents:

  1. Entity Framework: There is already an open DataReader associated with this Command
  2. Linq: adding conditions to the where clause conditionally
  3. Entity framework linq query Include() multiple children entities
  4. How to filter nested collection Entity Framework objects?
  5. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  6. Only initializers, entity members, and entity navigation properties are supported
  7. Convert String to Int in EF 4.0
  8. Linq-to-entities – Include() method not loading
  9. Instantiating a context in LINQ to Entities
  10. conditional include in linq to entities?
  11. EF 4: Removing child object from collection does not delete it – why?
  12. Linq To Entities – how to filter on child entities
  13. Entity Framework, Code First and Full Text Search
  14. LINQ OrderBy not ordering .. changing nothing .. why?
  15. Simple Linq query has duplicated join against same table?
  16. What are the benefits of a Deferred Execution in LINQ?
  17. LINQ recursion function?
  18. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  19. LEFT JOIN in LINQ to entities?
  20. Linq to EntityFramework DateTime
  21. LINQ: Dot Notation vs Query Expression
  22. Learning about LINQ [closed]
  23. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  24. How to compare only date components from DateTime in EF?
  25. How to Bulk Update records in Entity Framework?
  26. Entity Framework 6 Code First Custom Functions
  27. PowerShell equivalent of LINQ Any()?
  28. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  29. OrderBy descending in Lambda expression?
  30. LINQ: How to convert the nested hierarchical object to flatten object

Leave a Comment