可以使用 LINQ to SQL 查询 NOT IN 吗?
例如,SELECT au_lname, state FROM authors WHERE state NOT IN ('CA', 'IN', 'MD')
例如,SELECT au_lname, state FROM authors WHERE state NOT IN ('CA', 'IN', 'MD')
List<string> states = new List<string> { "CA", "IN", "MD" };
var q = from a in authors
where !states.Contains(a.state)
select new { a.au_lname, a.state };
或者 var q = authors.Where( a => !states.Contains( a.state ) )
.Select( a => new { a.au_lname, a.state } );
var states = new[] {"CA", "IN", "MD"};
var query = db.Authors.Where(x => !states.Contains(x.state));
这里有一个例子:
NorthwindDataContext dc = new NorthwindDataContext();
dc.Log = Console.Out;
var query =
from c in dc.Customers
where !(from o in dc.Orders
select o.CustomerID)
.Contains(c.CustomerID)
select c;
foreach (var c in query) Console.WriteLine( c );
是的!
这里有一个我们已经编写好的代码示例:
List<long> badUserIDs = new List { 10039309, 38300590, 500170561 };
BTDataContext dc = new BTDataContext();
var items = from u in dc.Users
where !badUserIDs.Contains(u.FbUserID)
select u;