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

by

This cannot work because ppCombined is a collection of objects in memory and you cannot join a set of data in the database with another set of data that is in memory. You can try instead to extract the filtered items personProtocol of the ppCombined collection in memory after you have retrieved the other properties from the database:

var persons = db.Favorites
    .Where(f => f.userId == userId)
    .Join(db.Person, f => f.personId, p => p.personId, (f, p) =>
        new // anonymous object
        {
            personId = p.personId,
            addressId = p.addressId,   
            favoriteId = f.favoriteId,
        })
    .AsEnumerable() // database query ends here, the rest is a query in memory
    .Select(x =>
        new PersonDTO
        {
            personId = x.personId,
            addressId = x.addressId,   
            favoriteId = x.favoriteId,
            personProtocol = ppCombined
                .Where(p => p.personId == x.personId)
                .Select(p => new PersonProtocol
                {
                    personProtocolId = p.personProtocolId,
                    activateDt = p.activateDt,
                    personId = p.personId
                })
                .ToList()
        });

More Related Contents:

  1. The type of one of the expressions in the join clause is incorrect in Entity Framework
  2. LEFT OUTER JOIN in LINQ
  3. Dynamic where clause (OR) in Linq to Entities
  4. How to perform Join between multiple tables in LINQ lambda
  5. “A lambda expression with a statement body cannot be converted to an expression tree”
  6. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  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. LINQ join two DataTables
  11. Recursive Hierarchy – Recursive Query using Linq
  12. Filter/Search using Multiple Fields – ASP.NET MVC
  13. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  14. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  15. The result of a query cannot be enumerated more than once
  16. How to convert an expression tree to a partial SQL query?
  17. Generate EF orderby expression by string [duplicate]
  18. Entity-framework code is slow when using Include() many times
  19. The operation cannot be completed because the DbContext has been disposed using MVC 4
  20. How does LINQ expression syntax work with Include() for eager loading
  21. Export Model to DataTable
  22. Dynamic query with OR conditions in Entity Framework
  23. Simulating Cross Context Joins–LINQ/C#
  24. Only primitive types or enumeration types are supported in this context
  25. Calling a SQL User-defined function in a LINQ query
  26. Max return value if empty query
  27. Check if list contains item from other list in EntityFramework
  28. How to do an “in” query in entity framework?
  29. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment