public List <EmployeeLookupDto> Lookup() { List <EmployeeLookupDto> lstEmployeeLookupDto = new List <EmployeeLookupDto>(); List <uspEmployeeLookUp_Result> lstuspEmployeeLookUp_Result = _dbContext.uspEmployeeLookUp().ToList(); foreach (var objspresult in lstuspEmployeeLookUp_Result) { var objEmployeeLookupDto = Mapper.Map <uspEmployeeLookUp_Result, EmployeeLookupDto>(objspresult); lstEmployeeLookupDto.Add(objEmployeeLookupDto); } return(lstEmployeeLookupDto); }