public List <Employee> GetAllEmployee() { List <Employee> listEmp = new List <Employee>(); DataSet dataSet = new DataSet(); dataSet = dal.GetDataSet("select p.PersonID,p.FirstName,p.LastName,p.MiddleName,p.EmailPromotion from [Person].[Person_json] p;", null, false); EntityMapper <Employee> empMap = new EntityMapper <Employee>(); listEmp = empMap.GetSafeResult(dataSet.Tables[0], EmployeeMapper); return(listEmp); }