Error: Unable to add data connection

Question

 please slove this error. urgent

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.