public IEnumerable <EmployeeModel> getAllEmployee() { List <EmployeeModel> empList = new List <EmployeeModel>(); SqlDataReader sdr = DBTask.ExecuteReader(Startup.ConnectionStringTS, "spGetEmployee", "GetAll", "", "", "", "", ""); if (sdr.HasRows) { while (sdr.Read()) { var emp = new EmployeeModel { empID = Convert.ToString(sdr["empID"]), empName = Convert.ToString(sdr["empName"]), empSalary = Convert.ToString(sdr["empSalary"]), DeptName = Convert.ToString(sdr["DeptName"]), DesigName = Convert.ToString(sdr["DesigName"]) }; empList.Add(emp); } } return(empList); }