title: Linq to SQL lambda join
body: <p>Having trouble with this, I've tried following several examples but I am just not getting it. It makes perfect sense using the non-lambda way, but how do I do a join using lambda expressions?</p>
  
  <pre><code>var myCats = GetAllCats();
  var myHouses = GetAllHouses();
  
  // pseudosql:  select * from a inner join b on a.id = b.id
  </code></pre>
  
  <p>I have tried this:</p>
  
  <pre><code>var fullData = myCats.Join(myHouses, a =&gt; a.id, b =&gt; b.id, (a, b) =&gt; a);
  </code></pre>
  
  <p>which I kind of got through looking at other examples on SO, but fullData  is type <code>IEnumerable&lt;Cat&gt;</code> so I can't pull any properties from Houses off it.</p>