title: JOIN and LEFT JOIN equivalent in LINQ
body: <p>I am working with the following SQL query:</p>
  
  <pre><code>SELECT 
  a.AppointmentId,
  a.Status,
  a.Type,
  a.Title,
  b.Days,
  d.Description,
  e.FormId
  FROM Appointment a (nolock)
  LEFT JOIN AppointmentFormula b (nolock)
  ON a.AppointmentId = b.AppointmentId and b.RowStatus = 1
  JOIN Type d (nolock)
  ON a.Type = d.TypeId
  LEFT JOIN AppointmentForm e (nolock)
  ON e.AppointmentId = a.AppointmentId
  WHERE a.RowStatus = 1
  AND a.Type = 1
  ORDER BY a.Type
  </code></pre>
  
  <p>I am unsure how to achieve the JOINs in LINQ.  All my tables have foreign key relationships.</p>