How can you handle an IN sub-query with LINQ to SQL?

by

General way to implement IN in LINQ to SQL

var q = from t1 in table1
        let t2s = from t2 in table2
                  where <Conditions for table2>
                  select t2.KeyField
        where t2s.Contains(t1.KeyField)
        select t1;

General way to implement EXISTS in LINQ to SQL

var q = from t1 in table1
        let t2s = from t2 in table2
                  where <Conditions for table2>
                  select t2.KeyField
        where t2s.Any(t1.KeyField)
        select t1;

More Related Contents:

  1. How to store a list in a column of a database table
  2. Linq version of SQL “IN” statement
  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. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  19. Escaping keyword-like column names in Postgres
  20. Why are there gaps in my IDENTITY column values?
  21. GROUP BY + CASE statement
  22. How do I return rows with a specific value first?
  23. Casting NULL type when updating multiple rows
  24. How can I do a BEFORE UPDATED trigger with sql server?
  25. Store multiple bit values in a single table column
  26. Group All Related Records in Many to Many Relationship, SQL graph connected components
  27. How do I call an Oracle stored procedure from an Excel VBA script?
  28. How to subtract 30 days from the current date using SQL Server
  29. PostgreSQL: top n entries per item in same table
  30. How to do a case sensitive GROUP BY?

Leave a Comment