Linq to SQL how to do “where [column] in (list of values)”

by

Use

where list.Contains(item.Property)

Or in your case:

var foo = from codeData in channel.AsQueryable<CodeData>()
          where codeIDs.Contains(codeData.CodeId)
          select codeData;

But you might as well do that in dot notation:

var foo = channel.AsQueryable<CodeData>()
                 .Where(codeData => codeIDs.Contains(codeData.CodeId));

More Related Contents:

  1. LINQ-to-SQL vs stored procedures? [closed]
  2. Linq: adding conditions to the where clause conditionally
  3. LINQ Between Operator
  4. LINQ across multiple databases
  5. Learning about LINQ [closed]
  6. How can I reject all changes in a Linq to SQL’s DataContext?
  7. LINQ with SQLite (linqtosql)
  8. How to create a dynamic LINQ join extension method
  9. LINQ not updating on .SubmitChanges()
  10. How to dynamically add OR operator to WHERE clause in LINQ
  11. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  12. Linq To Sql – Dynamic OrderBy – Case When
  13. Is there a pattern using Linq to dynamically create a filter?
  14. Multiple WHERE clause in Linq
  15. How do I write this cross apply query in LINQ-to-SQL?
  16. Point connectionstring in dbml to app.config
  17. Building Dynamic LINQ Queries based on Combobox Value
  18. NHibernate vs LINQ to SQL
  19. LINQ: Distinct values
  20. Entity Framework: There is already an open DataReader associated with this Command
  21. How can I conditionally apply a Linq operator?
  22. LINQ to SQL – Left Outer Join with multiple join conditions
  23. How to view LINQ Generated SQL statements?
  24. TransactionScope vs Transaction in LINQ to SQL
  25. How to write Asynchronous LINQ query?
  26. How do you perform a CROSS JOIN with LINQ to SQL?
  27. Sum of items in a collection
  28. Is there a difference between Select * and Select [list each col] [duplicate]
  29. Greater Than Condition in Linq Join
  30. LINQ: How to convert the nested hierarchical object to flatten object

Leave a Comment