public List <Model.RegionModel> GetAll2() { List <Model.RegionModel> list = new List <Model.RegionModel>(); SqlCommand Cmd = new SqlCommand(); Cmd.CommandText = "select * from Region"; SqlDataReader Dr = _DBHelper.Select(Cmd); while (Dr.Read()) { list.Add(new Model.RegionModel() { RegionID = Convert.ToInt32(Dr["RegionID"].ToString()), RegionDescription = Dr["RegionDescription"].ToString() }); } Dr.Close(); return(list); }