title: Convert SQL to Lambda Expression with one to many relationships
body: <p>I need to convert the following sql expression to c# lambda syntax:</p>
  
  <pre><code>SELECT PatientProfiles.PatientLastName, 
         Visits.VisitId, 
         Visits.VisitDate, 
         Visits.EndVisitDate 
  FROM Visits 
  INNER JOIN PatientProfiles ON 
                 Visits.PatientProfile_PatientId = PatientProfiles.PatientId 
  </code></pre>
  
  <p><code>PatientProfile_PatientId</code> is foreign key in Visit table. <code>Patient -&gt; Visit</code> has one to many relationship. I need to be able pull all visits from the Visit table along with Patient Name from PatientProfile parent table.</p>