title: Entity framework left join
body: <p>How do I change this query so it returns all u.usergroups?</p>
  
  <pre><code>from u in usergroups
  from p in u.UsergroupPrices
  select new UsergroupPricesList
  {
  UsergroupID = u.UsergroupID,
  UsergroupName = u.UsergroupName,
  Price = p.Price
  };
  </code></pre>