I've created a LINQ to SQL DataContext class. The designer shows the correct joins on the tables.
How do I query the joined tables in the from clause? Do I need to still specify the join in the code?
Also can I do the join to the second table only if I need it? i.e. I only need to join the table to search values in one of the columns if there are some values provided.
var query = from o in db.CommercialOrgs
// query = new query with left outer join
// based on CommercialOrgs and another table