var quer=(from dh in Deal_BlendedIncomeHeaders
join dd in Deal_BlendedIncomeDetails
on dh.BlendedHeaderID equals dd.BlendedHeaderID
join a in AdminFee_Earneds
on new {dd.BlendedDetailID,IsActive=1} equals new {a.BlendedDetailID,a.IsActive} into temp
from t in temp.DefaultIfEmpty()
select new {
dh.BlendedHeaderID
,dd.BlendedIncomeName
,dd.Amount
,AdminFeeEarnedID =(int?)t.AdminFeeEarnedID
}).Dump();
The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'GroupJoin'. Getting this error in query
VulpesPosted Jul 17, 2013, 6:37 AM
So, I'd try:
VulpesPosted Jul 16, 2013, 11:57 AM
Jignesh TrivediPosted Jul 16, 2013, 7:49 AM
try...
var quer=(from dh in Deal_BlendedIncomeHeaders
join dd in Deal_BlendedIncomeDetails
on dh.BlendedHeaderID equals dd.BlendedHeaderID
join a in AdminFee_Earneds
on new {ID = dd.BlendedDetailID,IsActive=1} equals new {ID = a.BlendedDetailID,IsActive= a.IsActive} into temp
from t in temp.DefaultIfEmpty()
select new {
dh.BlendedHeaderID
,dd.BlendedIncomeName
,dd.Amount
,AdminFeeEarnedID =(int?)t.AdminFeeEarnedID
}).Dump();
hope this will help you.