I have this data below and linq query sum. But I don't know why its output is not what I expected.
DateFiled - TotalDays - Cancelled - TypeId - EmpId
05/04/17 - 2 - False - 5 - 2
05/04/17 - 3 - False - 5 - 2
var TotalDays = (from a in db.Headers join b in db.Details on a.HeaderId equals b.HeaderId where a.DateFiled.Value.Year == DateTime.Now.Year && a.LeaveTypeId == 5 && a.IsCancelled != true && a.EmployeeId == empId select a.TotalDays).Sum();
Is there any wrong with my query?.</div