hai I am writing Joins in Linq to entities . here i am using 3 tables . but i got error like "The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to Join"
Here my Code is
from A in db.table1
join B in db.table2 on A.id equals B.pid
join C in db.table3 on B.id equals C.ris
where A.Bid == "7521"
select new { C.ID};
VulpesPosted Mar 5, 2014, 5:32 AM
dilipkumar reganaPosted Mar 5, 2014, 12:57 AM
Jignesh TrivediPosted Mar 4, 2014, 11:14 PM
hi,
I think this due to type mismatch between column(property) used in join.
you have appropriate type cast in join
Please provide property information of the classes which are used in join.
VulpesPosted Mar 4, 2014, 9:33 AM
join C in db.table3 on B.pid equals C.ris
If that's not the answer, then what are the types of : A.id. B.pid, B.id and C.ris?
Lakshmanan Sethu SankaranarayanPosted Mar 4, 2014, 9:26 AM