how to get the data in lambda expwhere user id not in(123)

Question

hi frnds in sql we get the record using query like below. select * from [User] where UserID not in(123). The same thing i want to do using lambda expression. i m using EF and lambda expression. can u help me out pls.???

Mukesh Kumar Tiwari · Answer

Khagesh Thanks for reply and i get adjact soluation which is below. List lstUserIds = dataContext.AddBuddies.Where(c => c.FromId == inputUserID).Select(c=>c.User1.UserID).ToList(); List dalUserList = dataContext.Users.Where(c => !lstUserIds .Contains(c.UserID)).ToList(); or List dalUserList = dataContext.Users.Where(c => lstUserIds .Contains(c.UserID)==false).ToList(); Same query in sql like where userID not in(more then on user id).

Khargesh Rajput · Answer

http://www.dotnetfunda.com/interviews/show/5457/how-to-implement-not-in-clause-in-linqlambda-query-expressionexplain-w https://paragy.wordpress.com/2010/11/18/lambda-expression-for-sql-where-in-clause/

how to get the data in lambda expwhere user id not in(1,2,3)