LINQ to SQL in and not in

by

You use, where <list>.Contains( <item> )

var myProducts = from p in db.Products
                 where productList.Contains(p.ProductID)
                 select p;

Or you can have a list predefined as such:

int[] ids = {1, 2, 3};

var query = from item in context.items
            where ids.Contains( item.id )
            select item;

For the ‘NOT’ case, just add the ‘!’ operator before the ‘Contains’ statement.

More Related Contents:

  1. LINQ’s Distinct() on a particular property
  2. LINQ query on a DataTable
  3. ‘Contains()’ workaround using Linq to Entities?
  4. Use LINQ to get items in one List, that are not in another List
  5. Concat all strings inside a List using LINQ
  6. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  7. Operation could destabilize the runtime?
  8. LINQ: Using INNER JOIN, Group and SUM
  9. Filling a DataSet or a DataTable from a LINQ query result set
  10. Prevent duplicates from array, based on condition [closed]
  11. Where is likely the performance bug here? [closed]
  12. Combining two expressions (Expression)
  13. LINQ : Dynamic select
  14. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  15. Bulk-deleting in LINQ to Entities
  16. How to parse a string into a nullable int
  17. Linq select objects in list where exists IN (A,B,C)
  18. Could not find an implementation of the query pattern
  19. Does Distinct() method keep original ordering of sequence intact?
  20. Display progress bar while doing some work in C#?
  21. ascending/descending in LINQ – can one change the order via parameter?
  22. Using LINQ to concatenate strings
  23. C# Pass Lambda Expression as Method Parameter
  24. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  25. Multiple WHERE Clauses with LINQ extension methods
  26. Serialize an object to XElement and Deserialize it in memory
  27. Update XML with C# using Linq
  28. Add the where clause dynamically in Entity Framework
  29. Split a List into groups of consecutive numbers [closed]
  30. Select multiple fields group by and sum

Leave a Comment