title: Linq to SQL multiple Left joins using multiple fields and subquery
body: <p>Basically I want to be able to recreate this query in Linq </p>
  
  <pre><code>SELECT * 
  FROM Customers
  
  LEFT JOIN Orders LastOrder
  ON LastOrder.CustomerId = Customers.CustomerId
  &amp;&amp; LastOrder.CreatedOn = (Select MAX(CreatedOn) FROM Orders WHERE CustomerId = Customers.CustomerId)
  
  LEFT JOIN OrderStatus
  ON OrderStatus.OrderStatusId = LastOrder.OrderStatusId
  </code></pre>