title: Linq join result to List
body: <p>Here is a linq inner join which returns what I want</p>
  
  <pre><code> var innerJoinQuery =
                  from employee in DbSet
                  join department in DbContext.Set&lt;Departments&gt;() on employee.DepartmentID equals department.ID
                  select new { ID = employee.ID, FirstName = employee.FirstName, LastName = employee.LastName, DepartmentID = employee.DepartmentID, DepartmentName = department.Name };
  
  
              List&lt;Employees&gt; innerjoinresult_as_employees_list = innerJoinQuery.AsEnumerable().Cast&lt;Employees&gt;().ToList();
  </code></pre>
  
  <p>Model of Employees is:</p>
  
  <pre><code>public class Employees
      {
          public int ID { get; set; }   
  
          [Required]
          public string FirstName { get; set; }
          [Required]
          public string LastName { get; set; }
  
          public int DepartmentID { get; set; }
  
          [NotMapped]
          public string DepartmentName { get; set; }
      }
  </code></pre>
  
  <p>My problem is that I cannot have var innerJoinQuery as <code>List&lt;Employees&gt;</code> so I can return it.</p>
  
  <p>Does anyone knows how to do this?</p>