Example #1
0
        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);
        }