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