title: Multi Includes Timeout
body: <p>I am using EF 6.1.1 and I am trying pull back data using the LINQ query below. I could write this query by hand in less than 30 lines, but entity framework is doing it IN THOUSANDS. See the SQL below, am I missing something?</p>
  
  <p><strong>LINQ</strong></p>
  
  <pre><code>_UserRepository
              .Query()
              .Include(a =&gt; a.PaymentSchedules)
              .Include(a =&gt; a.Profile.ProfileImages)
              .Include(a =&gt; a.Profile.ProfileImages.Select(c =&gt; c.Image.HomePageImage))  //&lt;&lt;&lt; this causes 100+ joins
              .Include(a =&gt; a.Profile.ProfileImages.Select(i =&gt; i.Image.HoverOverImage)) //&lt;&lt;&lt; this causes 100+ joins
              .AsQueryable()
              .Where(a =&gt; a.PaymentSchedules.Any(p =&gt; p.Active == true &amp;&amp; p.DatePaid &gt; eighthOfMonth))
              .Where(a =&gt; a.Profile.ProfileImages.Any(prof =&gt; prof.CurrentImage == true))
              .Select(a =&gt; a.Profile)
              .OrderBy(a =&gt; a.Id) //require for using skip
              .Skip(skipInt)
              .Take(takeInt)
              .ToList();
  </code></pre>
  
  <p><strong>SQL</strong></p>
  
  <p>**Stackoverflow won't even allow me to post the SQL because it is larger than 100K characters and contains over 200 left joins!!</p>
  
  <p>Please help.</p>
  
  <p>** Edited: copy paste fail.</p>