Linq version of SQL “IN” statement

by

Something like

var TagIds = new int[] {12, 32, 42};

var q = from map in Context.TagMaps 
        where TagIds.Contains(map.TagId)
        select map.Items;

should do what you need. This will generate an In ( 12, 32, 42 ) clause (or more specifically a parameterized IN clause if I’m not mistaken).

More Related Contents:

  1. How to store a list in a column of a database table
  2. How can you handle an IN sub-query with LINQ to SQL?
  3. Is there a difference between Select * and Select [list each col] [duplicate]
  4. LINQ to SQL query using “NOT IN”
  5. Linq to SQL: How do I stop the auto generated object name from being renamed?
  6. query sql between two tables [duplicate]
  7. SQL to LINQ with multiple join, count and left join
  8. SQL to LINQ Tool [closed]
  9. efficient way to implement paging
  10. LINQ to SQL – Left Outer Join with multiple join conditions
  11. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  12. What does Include() do in LINQ?
  13. Hierarchical data in Linq – options and performance
  14. How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?
  15. How to make LINQ execute a (SQL) LIKE range search
  16. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  17. Entity Framework Skip/Take is very slow when number to skip is big
  18. Splitting string into multiple rows in Oracle
  19. SQL JOIN vs IN performance?
  20. Microsoft Jet wildcards: asterisk or percentage sign?
  21. SQL Server 2008 – Help writing simple INSERT Trigger
  22. Use cases for NoSQL [closed]
  23. Deferrable Constraints in SQL Server
  24. Use Access SQL to do a grouped ranking
  25. SQL Server equivalent to MySQL enum data type?
  26. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. What does collation mean?
  29. Try_Convert for SQL Server 2008 R2
  30. converting int to real in sqlite

Leave a Comment