I second what Tomas Takac is saying. I do not understand the necessity to do join once in the sql query and then again in linq. Why not get the joined data directly from sql?
But if you are looking at code to convert datatable to List<employee>, then create a new object of employee class and set the property values from the datarow.
E.g.
select new Employee
{
Name = dr.Field<string>("name"),
Department = dr.Field<string>("department")
...
};
</string></string>