title: linq to sql join on multiple columns using lambda
body: <p>Can someone help me to translate this</p>
  
  <pre><code>var query = from s in context.ShoppingMalls
  join h in context.Houses
  on
  new { s.CouncilCode, s.PostCode }
  equals
   new { h.CouncilCode, h.PostCode }
  select s;
  </code></pre>
  
  <p>into lambda query?</p>
  
  <p>Thanks.</p>