How to get sum of a column of data type timespan in LINQ

See more:

C#

LINQ

entity-framework

I have Two tables on is Employees and other is Employeeschedules. Id column of Employees have foreign key relation with EmployeeId column of Employeeschedules table.

Employees Model Class


public class Employee : ModelBase<employee>
{
public string Name { get; set; }

public bool IsDeleted { get; set; }
}

Employeeschedules Model Class


public class EmployeeSchedule : ModelBase<employeeschedule>
{

[ForeignKey("Employee"),Required]
public long EmployeeId { get; set; }
public virtual Employee Employee { get; set; }
public DateTime Date { get; set; }

[Required]
public DateTime FromHours { get; set; }

[Required]
public DateTime ToHours { get; set; }

[Required]
public bool SlotStatus { get; set; }

[Required]
public TimeSpan TotalHours { get; set; }
}


I want result Like this


EmployeeId Name TotalHours
1 Mohan 3:00:00
2 Sarvan 2:30:00
5 Yogesh 1:00:00
3 Abhishek 0:30:00

What I have tried:

var empsch = from e in Db.Employees
join es in Db.EmployeeSchedules
on e.Id equals es.EmployeeId into j1
from j2 in j1.DefaultIfEmpty()
group j2 by e.Id into grouped
select new { EmployeeId=grouped.Key,Name= grouped.Select(t => t.Employee.Name), TotalHours=???
};