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