title: Multiple Left Outer Joins in LinqToSql?
body: <p>Is it possible to accomplish something like this using linqtosql?</p>
  
  <pre><code>select * from table t1
  left outer join table2 t2 on t2.foreignKeyID=t1.id
  left outer join table3 t3 on t3.foreignKeyID=t1.id
  </code></pre>
  
  <p>I can make it work using both DataLoad options or join syntax.  But the problem is whenever I add a second left join, linqtosql queries with MULTIPLE sql statements, instead of doing a second left join in the underlying sql.</p>
  
  <p>So a query like the one above will result in dozens of sql calls instead of one sql call with 2 left joins.</p>
  
  <p>What are my other options?  I can use a view in the DB, but now I'm responsible for creating the hierarchy from the flattened list, which is one of the reasons to use an ORM in the first place.</p>
  
  <p>Note that T2 and T3 are 1:M relationships with T1.  Is it possible to have linq efficiently query these and return the hierarchy?</p>