title: How to write a Linq to SQL join query with parameter which returns columns from both table?
body: <p>I can't figure out how to write this query in Linq:</p>
  
  <pre><code>select ic.icCategory, d.domHosting, d.domCode  
    from Domains d join Image_Categories ic 
      on ( d.domCode = ic.icDomainCode )
        where d.domCode = 'code'
  </code></pre>
  
  <p>Can anyone help? </p>
  
  <p>Thanks</p>