title: convert trans-sql to LINQ LEFT JOIN and Where Clause
body: <p>How would you convert this trans-sql to LINQ?</p>
  
  <p>I've tried it with the DefaultIfEmpty() but it seems to not be working for me.
  Any help is appreciated.</p>
  
  <pre><code>SELECT s.Status 
  FROM EducationModule M 
       LEFT JOIN EducationModuleStatus S ON  M.CourseID = S.CourseID 
                 AND M.ModuleID = S.ModuleID 
                 AND S.StudentID = '1506' 
  WHERE M.courseid = 2
  </code></pre>
  
  <p>Thanks in advance.</p>