LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context

by

You can’t use Contains with non-primitive values. Do

Where(l => l.Courses.Select(c => c.CourseId).Contains(courseId)

(or the Id field you use).

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. “A lambda expression with a statement body cannot be converted to an expression tree”
  4. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  5. Bulk-deleting in LINQ to Entities
  6. Entity framework left join
  7. Why doesn’t Include have any effect?
  8. Entity Framework/Linq EXpression converting from string to int
  9. Value cannot be null. Parameter name: source
  10. Recursive Hierarchy – Recursive Query using Linq
  11. Filter/Search using Multiple Fields – ASP.NET MVC
  12. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  13. The result of a query cannot be enumerated more than once
  14. Entity Framework. Delete all rows in table
  15. How to convert an expression tree to a partial SQL query?
  16. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  17. Entity-framework code is slow when using Include() many times
  18. The operation cannot be completed because the DbContext has been disposed using MVC 4
  19. How does LINQ expression syntax work with Include() for eager loading
  20. Export Model to DataTable
  21. Dynamic query with OR conditions in Entity Framework
  22. Simulating Cross Context Joins–LINQ/C#
  23. Only primitive types or enumeration types are supported in this context
  24. Calling a SQL User-defined function in a LINQ query
  25. Max return value if empty query
  26. Check if list contains item from other list in EntityFramework
  27. How to do an “in” query in entity framework?
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment