title: Left outter join linq
body: <p>How do i change the training events into a left outer join in  training events im very basic at linq so excuse my ignorance its not retrieve records that don't have any trainnevent reference attached to it  </p>
  
  <pre><code> var q = from need in pamsEntities.EmployeeLearningNeeds
                      join Employee e in pamsEntities.Employees on need.EmployeeId equals e.emp_no
                      join tevent in pamsEntities.TrainingEvents on need.TrainingEventId equals tevent.RecordId                            
                      where need.EmployeeId == employeeId
                      where need.TargetDate &gt;= startdate 
                      where need.TargetDate &lt;= enddate 
                      orderby need.TargetDat
  </code></pre>