Linq query error

Question

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

Answer 1

If it's a tinyint field, then it may be mapping to C#'s byte type.

So, I'd try:

join a in AdminFee_Earneds

on new {dd.BlendedDetailID,IsActive = (byte)1} 

equals new {a.BlendedDetailID,a.IsActive}

Answer 2

Just a WAG but the IsActive field sounds like it might be a bool rather than an int.

If that's the case, try:

join a in AdminFee_Earneds

on new {dd.BlendedDetailID,IsActive = true} 

equals new {a.BlendedDetailID,a.IsActive}

Answer 3

hi,
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.