from e in Db.Employees join es in Db.EmployeeSchedules on e.Id equals es.EmployeeId group es by {e.Id} into g select new {EmployeeId = g.EmployeeId , TotalHours = g.Sum(e => e.TotalHours)}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)