title: Joining multiple tables with LINQ
body: <p>I am trying to convert this query to a LINQ query:</p>
  
  <pre><code>select proj.CustomerName, proj.projectid, ProjectNumber, oe.FullName, oe.Rate, oe.jobid, opj.BillRate, hours.Hours, hours.WeekStart 
      from RMT_TaskEmployeeHours hours
  
          join OracleEmployees oe
          on hours.EmployeeNumber = oe.EmployeeNumber
  
              join OracleProjectTasks tasks
              on hours.TaskId = tasks.TaskID
  
                  join OracleProjects proj
                  on tasks.ProjectID = proj.ProjectID
  
                      left join OracleProjectJobs opj
                      on opj.ProjectID = proj.ProjectID
                      and oe.jobid = opj.JobID
                      where oe.Office  like '%san francisco%'
                      and opj.EndDate is null
                      and WeekStart &gt; '2015-1-22' and WeekStart &lt; '2015-2-19'
  </code></pre>
  
  <p>I got stuck after writing:</p>
  
  <pre><code>var test = db.RMT_TaskEmployeeHours.
                     Join(
                         db.OracleEmployees,
                         hours =&gt; hours.EmployeeNumber,
                         oe =&gt; oe.EmployeeNumber,
                         (hours, oe) =&gt; new {hours, oe}).
                     Join(
                          db.OracleProjectTasks,
                          oh =&gt; oh.oe.
                     ).
  </code></pre>