title: how to compare null in join linq syntax
body: <p>Work on EF 4 C#.Face problem in join . sql syntax</p>
  
  <pre><code>Select a.Code, b.Name from DepartmentMaster a
  Join DepartmentDetail  b on isnull( a.ID,0) =isnull( b.ID,0)
  </code></pre>
  
  <p><strong>Note:</strong> a.ID ,b.ID Both are nullable </p>
  
  <p>Want above syntax out put in Linq syntax .Bellow syntax is not working for me </p>
  
  <pre><code>Var r=from a in DepartmentMaster
  Join b in DepartmentDetail  on a.ID equals b.ID
  Select a.Code,b.Name
  </code></pre>
  
  <p>Need help to  write sql syntax isnull() comparable process in linq ef.</p>
  
  <p>If have any query please ask.</p>