The type of one of the expressions in the join clause is incorrect in Entity Framework

by

The types and the names of the properties in the anonymous types must match:

new { p1 = q.QOT_SEC_ID, p2 = dpr.DPR_TS } 
    equals 
new { p1 = (decimal)p.PAY_SEC_ID, p2 = p.PAY_DATE }

or if p.PAY_SEC_ID were an int?:

new { p1 = (int?)q.QOT_SEC_ID, p2 = dpr.DPR_TS } 
    equals 
new { p1 = p.PAY_SEC_ID, p2 = p.PAY_DATE }

…which will find no matches PAY_SEC_ID is null, or

new { p1 = q.QOT_SEC_ID, p2 = dpr.DPR_TS } 
    equals 
new { p1 = p.PAY_SEC_ID.GetValueOrDefault(), p2 = p.PAY_DATE }

…which defaults p1 to 0 when PAY_SEC_ID is null and again no match will be found (assuming that ID values will never be 0).

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. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  5. “A lambda expression with a statement body cannot be converted to an expression tree”
  6. Bulk-deleting in LINQ to Entities
  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 LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  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. Linq: help me to make this work
  17. How to do joins in LINQ on multiple fields in single join
  18. Linq-to-Entities Join vs GroupJoin
  19. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  20. Linq to Entities, random order
  21. Linq to EntityFramework DateTime
  22. LINQ to SQL multiple tables left outer join
  23. LINQ: combining join and group by
  24. How to Bulk Update records in Entity Framework?
  25. Entity Framework. Delete all rows in table
  26. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  27. How to tell if an IEnumerable is subject to deferred execution?
  28. Select all columns after JOIN in LINQ
  29. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  30. Is it possible to perform joins across different databases using LINQ?

Leave a Comment