title: Linq to Sql: Multiple left outer joins
body: <p>I'm having some trouble figuring out how to use more than one left outer join using LINQ to SQL.  I understand how to use one left outer join.  I'm using VB.NET.  Below is my SQL syntax.</p>
  
  <p><strong>T-SQL</strong></p>
  
  <pre><code>SELECT
      o.OrderNumber,
      v.VendorName,
      s.StatusName
  FROM
      Orders o
  LEFT OUTER JOIN Vendors v ON
      v.Id = o.VendorId
  LEFT OUTER JOIN Status s ON
      s.Id = o.StatusId
  WHERE
      o.OrderNumber &gt;= 100000 AND
      o.OrderNumber &lt;= 200000
  </code></pre>