public override List <ProductPackage> GetProductPackageList() { List <ProductPackage> list = new List <ProductPackage>(); using (SqlConnection connection = this.GetSqlConnection()) { string cmdText = "select * from SuCommerce_ProductPackage"; SqlCommand command = new SqlCommand(cmdText, connection) { CommandType = CommandType.Text }; connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { ProductPackage package = null; while (reader.Read()) { package = new ProductPackage(); CommerceDataProvider.PopulateProductPackageList(reader, package); list.Add(package); } reader.Close(); connection.Close(); } } return(list); }