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);
}
