linq not in 查询

Select ProductID, ProductName, CategoryID
From dbo.Products
Where CategoryID in (1, 2)

		

var queryResult = from p in db.Products
where (new int[] ...{1,2}).Contains(p.CategoryID)
select p;

				

Select ProductID, ProductName, CategoryID
From dbo.Products
Where CategoryID not in (1, 2)

				

var queryResult = from p in db.Products
where !(new int[] ...{1,2}).Contains(p.CategoryID)
select p;

		

from a in TableA where !(from b in TableB Where ... select b.Id).Contains(a.Id)

		

//比如 Id in (1,2,3)

int[] a=...{1,2,3};
list.Where(x=>a.Contains(x.Id))