LINQ to SQL query using "NOT IN"

Question

Can LINQ to SQL query using NOT IN?

e.g., SELECT au_lname, state FROM authors WHERE state NOT IN ('CA', 'IN', 'MD')

Answer 1

    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 }; 

or

   var q = authors.Where( a => !states.Contains( a.state ) )                   .Select( a => new { a.au_lname, a.state } ); 

Answer 2

You can do it with Contains:

       var states = new[]  {"CA", "IN", "MD"};        var query = db.Authors.Where(x => !states.Contains(x.state));