title: IQueryable<T> Join with Where Condition Entity Framework 6.0
body: <p>I am trying to use where condition with <code>IQueryable&lt;T&gt;</code> Join approach but find no resources to give me clue how how to filter records based on child table field.</p>
  
  <p>e.g Normal query that I want to execute via <code>IQueryable&lt;T&gt;</code> Linq Statement:</p>
  
  <pre><code>Select 
      m.* 
  from 
      vsk_media as m 
  inner join 
      vsk_media_album as v 
  on 
      m.id=v.mediaid 
  where 
      v.albumid=47
  </code></pre>
  
  <p>Here is my code which works well without where statement:</p>
  
  <pre><code>IQueryable&lt;vsk_media&gt; Query = entities.vsk_media;
         Query.Join(entities.vsk_media_albums
         , c =&gt; c.id
         , cm =&gt; cm.mediaid
         , (c, cm) =&gt; new { c, cm });
  </code></pre>
  
  <p>Now how to add where condition to match with child table <code>vsk_media_albums</code> (where v.albumid=47) in above IQueryable Statement. </p>
  
  <p>I tried my best to find solution but not found any good resource in web. I am not interested in normal Linq Statement.</p>