Select * from EmployeeStatus es where Not exists (select * from RouteSectorStatus rS WHERE es.Employee_Id=rS.Employee_Id AND RouteSectorStatusDate='2015-05-20')
var theDate = new DateTime(2015, 5, 20); var data = context.EmployeeStatuses.Where( es => !context.RouteSectorStatuses.Any( rs => rs.Employee_Id == es.Employee_Id && rs.RouteSectorStatusDate == theDate));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)