Ever thought about writing the following query in Entity Framework?
SQL
xxxxxxxxxx
1
1
Select * From Employees e
2
left join Employees_Attendance ea on e.id=ea.employee_id and ea.date between {{startdate}} and {{enddate}}