I've been fiddling around with some queries and watching SQL Profiler to see if there is a difference between writing a query with an explicit join vs. using already existing associations. For example, with the Northwind db, when you create a datacontext from it, it picks up the relationships between suppliers and products. If I wanted to do a join query to get some aggregate data about order details, I could write something like this : var results = from c in db.Customers join o in db.Orders on
Read More...