0
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}
0
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}
0
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.