LINQ to SQL query using “NOT IN”

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

More Related Contents:

  1. How to store a list in a column of a database table
  2. Linq version of SQL “IN” statement
  3. How can you handle an IN sub-query with LINQ to SQL?
  4. Is there a difference between Select * and Select [list each col] [duplicate]
  5. Linq to SQL: How do I stop the auto generated object name from being renamed?
  6. What is the syntax for an inner join in LINQ to SQL?
  7. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  8. SQL to LINQ with multiple join, count and left join
  9. SQL to LINQ Tool [closed]
  10. efficient way to implement paging
  11. LINQ to SQL – Left Outer Join with multiple join conditions
  12. Fastest way to perform nested bulk inserts with scope_identity() usage?
  13. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  14. What does Include() do in LINQ?
  15. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  16. LINQ Where Ignore Accentuation and Case
  17. Operation could destabilize the runtime?
  18. How to select only the records with the highest date in LINQ
  19. Why use LINQ Join on a simple one-many relationship?
  20. Join and Include in Entity Framework
  21. Max or Default?
  22. How to use “contains” or “like” in a dynamic linq query?
  23. Closing connection when using Dapper
  24. How do I do a left outer join with Dynamic Linq?
  25. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  26. Get sum of two columns in one LINQ query
  27. Last and LastOrDefault not supported
  28. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  29. Entity Framework Skip/Take is very slow when number to skip is big
  30. Linq where column == (null reference) not the same as column == null

Leave a Comment