score:2

Accepted answer
var employee = db.employee.where(x => x.employeeid == id ).
               select(e => new { e.employeeid, e.firstname, e.lastname, e.dob, e.department.departmentname }).
               asenumerable().
               select(b => new
               {
                  id = b.employeeid, 
                  name = b.firstname + " " + b.lastname,
                  age = calculateage(b.dob.tostring()),
                  department = b.departmentname
                  } ).tolist();
if employee != null)
{
   dgvemployee.datasource = employee;
}

Related Query

More Query from same tag