title: EF include with where clause
body: <p>I've Resource and ResourceDetail. 
  MemberPoint with memberId and ResourceId.</p>
  
  <p>I would like to get Resources Details for a member.</p>
  
  <p>In SQL,</p>
  
  <pre><code>Select d.* From ResourceDetails d Inner Join 
          Resource on r d.ResourceId = r.Id Inner Join 
          MemberPoint mp on r.id = mp.ResourceId 
          where mp.memberId = 1
  </code></pre>
  
  <p>In EF,</p>
  
  <pre><code>   var query = _context.ResourceDetails
              .Include(d =&gt; d.Resource)
              .Include(r =&gt; r.Resource.Memberpoints)
              .Where(e =&gt; e.Resource.Memberpoints.Where(m =&gt; m.MemberId))
  </code></pre>
  
  <p>I got error when I write above EF query.</p>
  
  <p>Error: unknown method 'Where(?)'of System.Linq.IQueryable</p>