title: LINQ Include on a one-to-many with .Where() not working?
body: <p>I'm trying to query Users including each user's Interests, but only where an Interest meets certain criteria: </p>
  
  <pre><code>  return db.Users.Include(u =&gt; u.Interests.Where(s =&gt; s.TenantId == tenantId))
  </code></pre>
  
  <p>But I get an error: </p>
  
  <blockquote>
    <p>The Include path expression must refer to a navigation property
    defined on the type. Use dotted paths for reference navigation
    properties and the Select operator for collection navigation
    properties.</p>
  </blockquote>
  
  <p>I played with the idea of pushing the .Where outside, but haven't been able to get it working.</p>