title: How do I do this in Entity Framework (multiple where's or Join)?
body: <p>I have 2 tables that have a relation ship to each other</p>
  
  <p>Table A has 1 to many relationship with table B, so this creates a navigation property into each.</p>
  
  <p>Now I need to check a value from Table A (userName) and I need to check a value from table B (ClubId).</p>
  
  <p>So in my mind it would be something like</p>
  
  <pre><code>Join the tables together
  Where A.userName == "bob" &amp;&amp;
  where B.clubId == "Car"
  
  // return the count.
  </code></pre>
  
  <p>but now I know with Entity stuff it should make joins less common so I am wondering if I can do it with a join then.</p>
  
  <p>I tried this</p>
  
  <pre><code>int count = Entity.TableA.where(a =&gt; a.userName == "bob" &amp;&amp; a.TableB.where(i =&gt; i.ClubId == "Car")).Count();
  </code></pre>
  
  <p>so this does not work since it won't return the right type(the 2nd where). This is just how I thought along the lines how I would expect it to be done would work.</p>
  
  <p>So how should it look?</p>
  
  <p>P.S </p>
  
  <p>I rather have an example done in the Linq method queries like I did above.</p>