title: SQL to LINQ conversion failed
body: <p>I've an <code>sql</code> query like this:</p>
  
  <pre><code>select attendance.intime, attendance.outtime, attendance.date, employees.name from employees left join attendance on employees.id = attendance.employeeid where attendance.date = '12/12/2016'
  </code></pre>
  
  <p>I want to convert this to <code>LINQ</code> method syntax. I've tried this. </p>
  
  <pre><code>var attendances = db.Attendances.Include(a =&gt; a.Admin).Include(a =&gt; a.Employee);
  var employees = db.Employees.Include(a =&gt; a.Admin);
  
  var linq_query = attendances
                  .Join(
                      employees,
                      a =&gt; a.EmployeeId,
                      e =&gt; e.Id,
                      (a, e) =&gt; new { e.Name, a.InTime, a.OutTime, a.Date                                 
                   })
                   .Where(e=&gt; e.Date == DateTime.Parse("12/12/2016"));
  </code></pre>
  
  <p>But it's giving me 500 Internal server error. Where to change?</p>