title: LINQ to Entities (Entity Framework) Join and .Include conflict
body: <p>What I want to do seems pretty simple.  I want to select some employers and I want to include the last 6 quarterly data records sorted by year and quarter descending.</p>
  
  <p>Consider the Expression:</p>
  
  <pre><code>var query = from e in data.Employer.Include("EmployerQuarterly")
              where e.UIAccount == 22
              select e;
  </code></pre>
  
  <p>I'm on the right track because I get the 7 Employer records I wanted and each of those have all of the quarterly data. Now all I have to do is order that data and select only the top 6 records.</p>
  
  <p>This expression accomplishes the order by, but not the limit of 6.</p>
  
  <pre><code>var query = from e in data.Employer.Include("EmployerQuarterly")
              from q in e.EmployerQuarterly
              where e.UIAccount == 22
              orderby q.Year descending, q.Quarter descending
              select e;
  </code></pre>
  
  <p>The query above also has two undesired side-effects.  I now get back 208 records rather than my original 7 AND I no longer get back any EmployerQuarterly data!</p>
  
  <p>I don't want to sacrifice my eager loading. Is what I am asking for possible with L2E? </p>