title: Filtering navigation properties in LINQ
body: <p>I have a LINQ query that fetches a lot of data (shown below). This query is causing a timeout issue so I'm trying to filter it so that it only gets the needed records. I'm trying to get the Orders for a specific date. The date field is in the Order table but how do I muster that into the LINQ query below. I tried adding .Where(...) after the second .Include but that gives me errors.</p>
  
  <pre><code>var productEntities = _context.Set&lt;Product&gt;()
              .Include(p =&gt; p.OrderItems)
              .Include(p =&gt; p.OrderItems.Select(oi =&gt; oi.Order))
              .Include(p =&gt; p.OrderItems.Select(oi =&gt; oi.Order.Client))                
              .ToList();
  </code></pre>