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

Vulpes · Answer

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.BlendedDetailIDIsActive = (byte)1} equals new {a.BlendedDetailIDa.IsActive}

Vulpes · Answer

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.BlendedDetailIDIsActive = true } equals new {a.BlendedDetailIDa.IsActive}

Jignesh Trivedi · Answer

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.BlendedDetailIDIsActive=1} equals new {ID = a.BlendedDetailIDIsActive= 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.