how to write a linq query which make s.th. like where id != List

Question

Possible Duplicate:
How would you do a “not in” query with Linq?

I have a question about a LINQ query, I have a List<int> foo; and now I need to check something like:

var output = select a from db.User where a.id not in foo select a;

how can i realize this: a.id not in foo ?

Answer 1

If foo is a list then where !foo.Contains(a.id).

Answer 2

Use the contains method on the list

var output = from a in db.User where !foo.Contains(a.id) select a;

Answer 3

My Blog about this : SQL to LINQ ( Case 7 - Filter data by using IN and NOT IN clause)

You use, where <list>.Contains( <item> )

var foo = {1, 2, 3};
var users = from p in db.users
                 where !foo.Contains(p.id)
                 select p;

Image Representation of this