Not in Clause in Linq To SQl

Question

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...!!

Bikesh Srivastava · Answer

see this query. varquery=myEntities.MyEntity .Select(e=>e.Name) .Except(exceptionList);

Sathya Narayan · Answer

Hi Bikesh  Thanks for your reply i got the solution for that query.