title: LINQ Query - how sort and filter on eager fetch
body: <p>How do I do a eager query of a parent child relationship that:</p>
  
  <ol>
  <li>filters a on child  fields</li>
  <li>sorts on both parent and child</li>
  <li>return a List or Parents with the children pre-populated </li>
  </ol>
  
  <p>If I try</p>
  
  <pre><code>from p in _context.Parents.Include("children")
  join c in _context.childrenon p.Id equals c.ParentId 
  where d.DeletedDate == null
  orderby p.Name ascending, c.Name 
  select p
  </code></pre>
  
  <p>Then I get the Parent object back but each Parent has NULL for children</p>
  
  <p>if I try</p>
  
  <pre><code>from p in _context.Parents.Include("children")
  orderby p.Name ascending
  select p
  </code></pre>
  
  <p>The query returns all Parents and children but they are not filtered or sorted.</p>
  
  <p>The result I want back is a <code>IEnumerable&lt;Parent&gt;</code>
  i.e.</p>
  
  <pre><code>Parent[0].name = "foo"
  Parent[0].children = IEnumerable&lt;Child&gt;
  Parent[1].name = "bar"
  Parent[1].children = IEnumerable&lt;Child&gt;
  </code></pre>