2
Answers

Error: Unable to add data connection

Rupesh N

Rupesh N

7y
213
1
 please slove this error. urgent
Answers (2)
0
Vulpes

Vulpes

NA 98.3k 1.5m 11y
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
Vulpes

Vulpes

NA 98.3k 1.5m 11y
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
Jignesh Trivedi

Jignesh Trivedi

NA 61k 14.2m 11y
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.