title: Linq outer joins
body: <p>I need help to convert the following query to Linq</p>
  
  <pre><code>SELECT c.Code, c.Name
  from tblCodes as c
  where c.code not in 
      (select Code from npConsultant where ConsultantName = 'X')
      and c.Code &lt; 'AA.0000'
  </code></pre>
  
  <p>When I try in Linqpad it doesn't seem to understand the into or defaultifempty. Maybe these are inproper methods for what I need to do</p>