LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

by

Joining on multiple columns in Linq to SQL is a little different.

var query =
    from t1 in myTABLE1List // List<TABLE_1>
    join t2 in myTABLE1List
      on new { t1.ColumnA, t1.ColumnB } equals new { t2.ColumnA, t2.ColumnB }
    ...

You have to take advantage of anonymous types and compose a type for the multiple columns you wish to compare against.

This seems confusing at first but once you get acquainted with the way the SQL is composed from the expressions it will make a lot more sense, under the covers this will generate the type of join you are looking for.

EDIT Adding example for second join based on comment.

var query =
    from t1 in myTABLE1List // List<TABLE_1>
    join t2 in myTABLE1List
      on new { A = t1.ColumnA, B = t1.ColumnB } equals new { A = t2.ColumnA, B = t2.ColumnB }
    join t3 in myTABLE1List
      on new { A = t2.ColumnA, B =  t2.ColumnB } equals new { A = t3.ColumnA, B = t3.ColumnB }
    ...

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. What is the syntax for an inner join in LINQ to SQL?
  3. Difference Between Select and SelectMany
  4. Random row from Linq to Sql
  5. How do you perform a left outer join using linq extension methods
  6. Linq – left join on multiple (OR) conditions
  7. To return IQueryable or not return IQueryable [closed]
  8. LINQ to SQL and a running total on ordered results
  9. Operation is not valid while ItemsSource is in use. Access and modify elements with ItemsControl.ItemsSource instead
  10. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  11. Updating an ObservableCollection in a separate thread
  12. Convert Linq Query Result to Dictionary
  13. Using contains() in LINQ to SQL
  14. Persist Data by Programming Against Interface
  15. LINQ Inner-Join vs Left-Join
  16. LINQ Where Ignore Accentuation and Case
  17. Linq query with nullable sum
  18. C# LINQ to SQL: Refactoring this Generic GetByID method
  19. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  20. How to make LINQ execute a (SQL) LIKE range search
  21. Will using LINQ to SQL help prevent SQL injection
  22. Best way to update LINQ to SQL classes after database schema change
  23. Last and LastOrDefault not supported
  24. Multiple/single instance of Linq to SQL DataContext
  25. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  26. Is it possible to use SqlGeography with Linq to Sql?
  27. IDENTITY INSERT and LINQ to SQL
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment