List<int> empjList=ObjToList(employeeJobPositionIds); List<EmpJobPosition> empJobPositionList = (from i in ctx.EmpJobPositions where empjList.Contains(i.EmpJobPositionId) select i).ToList<EmpJobPosition>(); var query = (from emp in ctx.Employees join resg in ctx.Resignations on emp.EmployeeID equals resg.EmployeeID into resglist from resg in resglist.DefaultIfEmpty() join jpos in empJobPositionList on emp.EmployeeID equals jpos.EmployeeId into jposList from jpos in jposList.DefaultIfEmpty() where (resg == null || resg.HasLeft == false) && select new EmployeesViewModel()).ToList();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)