linq to sql: join multiple columns from the same table

by

This is the only way I was able to get it to work (in c#).

var qry = from t1 in table1
          join t2 in table2
          on new {t1.ID,t1.Country} equals new {t2.ID,t2.Country}
          ...

More Related Contents:

  1. What is the syntax for an inner join in LINQ to SQL?
  2. Is LINQ to SQL Dead or Alive?
  3. Does AutoMapper support Linq?
  4. How to do a join in linq to sql with method syntax?
  5. How do I update a Linq to SQL dbml file?
  6. LINQ: combining join and group by
  7. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  8. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  9. Explicit construction of entity type ‘###’ in query is not allowed.
  10. Why use LINQ Join on a simple one-many relationship?
  11. NOLOCK with Linq to SQL
  12. Common Table Expression (CTE) in linq-to-sql?
  13. Convert SQL to LINQ to SQL
  14. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  15. T4 template to Generate Enums
  16. Using System.Data.Linq in a Razor view
  17. How to display data in JOIN, and return null value? [closed]
  18. Why isn’t SQL ANSI-92 standard better adopted over ANSI-89?
  19. Why does X[Y] join of data.tables not allow a full outer join, or a left join?
  20. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  21. LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?
  22. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  23. Linq version of SQL “IN” statement
  24. LINQ Join with Multiple Conditions in On Clause
  25. LINQ and pagination [duplicate]
  26. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  27. MySQL Inner Join Query Multiple Tables
  28. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  29. MySQL LEFT JOIN 3 tables
  30. How to exclude rows that don’t join with another table?

Leave a Comment