title: How to use Linq in IQueryable
body: <p>I want to join two entities in IQueryable</p>
  
  <p>This is what I do:</p>
  
  <pre><code>IQueryable&lt;EmployeeSchedule&gt; employeeScheduleResult = 
      from empSched in ctx.EmployeeSchedules.ToList() 
      join emp in ctx.Employees.ToList() on empSched.EmployeeId equals emp.EmployeeId 
      select new {
          empSched.ScheduleId,
          empSched.ScheduleDt,
          empSched.Branch,
          empSched.StartTime,
          empSched.EndTime,
          empSched.LunchTime,
          empSched.LunchBreak,
          empSched.LunchBreak_NS,
          Employee = emp.LastName + emp.FirstName + emp.MiddleName
      };
  </code></pre>
  
  <p>And this is the error I receive:</p>
  
  <blockquote>
    <p>Cannot implicitly convert type 'System.Collections.Generic.IEnumerable' to 'System.Linq.IQueryable'. An explicit conversion exists (are you missing a cast?)</p>
  </blockquote>