title: How to make linq master detail query for 0..n relationship?
body: <p>Given a classic DB structure of Orders has zero or more OrderLines and OrderLine has exactly one Product, how do I write a LINQ query to express this?</p>
  
  <p>The output would be</p>
  
  <pre><code>OrderNumber - OrderLine - Product Name
  Order-1       null        null // (this order has no lines)
  Order-2       1           Red widget
  </code></pre>
  
  <p>I tried this query but is not getting the orders with no lines</p>
  
  <pre><code>var model = (from po in Orders
               from line in po.OrderLines
                  select new
                  {
                      OrderNumber = po.Id,
                      OrderLine = line.LineNumber,
                      ProductName = line.Product.ProductDescription,
                  }
               )
  </code></pre>