How to do a join in linq to sql with method syntax?

by 
var result = from sc in enumerableOfSomeClass
             join soc in enumerableOfSomeOtherClass
             on sc.Property1 equals soc.Property2
             select new { SomeClass = sc, SomeOtherClass = soc };

Would be equivalent to:

var result = enumerableOfSomeClass
    .Join(enumerableOfSomeOtherClass,
          sc => sc.Property1,
          soc => soc.Property2,
          (sc, soc) => new
                       {
                           SomeClass = sc,
                           SomeOtherClass = soc
                       });

As you can see, when it comes to joins, query syntax is usually much more readable than lambda syntax.

More Related Contents:

  1. Is LINQ to SQL Dead or Alive?
  2. Does AutoMapper support Linq?
  3. How do I update a Linq to SQL dbml file?
  4. Benchmark Linq2SQL, Subsonic2, Subsonic3 – Any other ideas to make them faster?
  5. ASP.MVC: Repository that reflects IQueryable but not Linq to SQL, DDD How To question
  6. Explicit construction of entity type ‘###’ in query is not allowed.
  7. NOLOCK with Linq to SQL
  8. Common Table Expression (CTE) in linq-to-sql?
  9. Convert SQL to LINQ to SQL
  10. C# Linq-to-Sql – Should DataContext be disposed using IDisposable
  11. T4 template to Generate Enums
  12. Using System.Data.Linq in a Razor view
  13. linq to sql: join multiple columns from the same table
  14. Difference Between Select and SelectMany
  15. LINQ to SQL Left Outer Join
  16. How to do a subquery in LINQ?
  17. How to store a list in a column of a database table
  18. To return IQueryable or not return IQueryable [closed]
  19. How can you handle an IN sub-query with LINQ to SQL?
  20. Using contains() in LINQ to SQL
  21. How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?
  22. Get table-data from table-name in LINQ DataContext
  23. DISTINCT() and ORDERBY issue
  24. How to make LINQ execute a (SQL) LIKE range search
  25. Best Practice: Convert LINQ Query result to a DataTable without looping
  26. Best way to update LINQ to SQL classes after database schema change
  27. Multiple/single instance of Linq to SQL DataContext
  28. Is it possible to use SqlGeography with Linq to Sql?
  29. How to define Many-to-Many relationship through Fluent API Entity Framework?
  30. Linq to SQL: How do I stop the auto generated object name from being renamed?

Leave a Comment