Loading

Not in Clause in Linq To SQl

Sathya Narayan

10y906LINQ

I have written a linq to sql query for not in clause for the table tblBranches.So i am getting this error.

The Best OverLoaded method match for system.collection.generic.list.Contains(Jeeves.branchBO)has some invalid arguments

var GetBranchDetail = (from C in objJCSDB.tblBranches

where !objListBranchBO.Any(C.BranchId)&& C.CityId==objBranchBO._CityId && C.IsActive==true.

Please Can any one help me...!!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sathya Narayan10y ago
Hi Bikesh ,
Thanks for your reply i got the solution for that query.
0
Bikesh Srivastava10y ago
see this query.
varquery=myEntities.MyEntity
.Select(e=>e.Name)
.Except(exceptionList);
+1