问题描述
可以使用 NOT IN 进行 LINQ to SQL 查询吗?
Can LINQ to SQL query using NOT IN?
例如,SELECT au_lname, state FROM author WHERE state NOT IN ('CA', 'IN', 'MD')
e.g., 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 } );