AC 7.0 - Querying DB option removed?

[AbleOne]

Hi Mike / Logan,
We used to have the nice hooks in 5.5 (cbDatabase Class - QueryArray, QueryArrayIC, QueryValue, etc) for querying the database from the codebehind without having to setup connection, recordset, etc... it was VERY useful for adhoc queries.

I don't see that in 7.0 API... do you still have it? If so, can you provide help on where it is?

If not, the connection string is encrypted and not sure which method to use to unencrypt it...

Let us know?

Thanks.
-sri
sri@awcs.net

[Logan Rhodehamel]

We have a similar database wrapper in AC7, though it is provided by the Microsoft enterprise library. Our database class is Microsoft.Practices.EnterpriseLibrary.Data.Database.

CommerceBuilder.Common.Token is a singleton, it provides a static property to get the current instance of the token:

Code: Select all

Token acToken = Token.Instance;

The token instance holds a reference to the database.

Code: Select all

Microsoft.Practices.EnterpriseLibrary.Data.Database database;
database = Token.Instance.Database;

The database class has useful methods like ExecuteScalar, ExecuteDataSet, and ExecuteReader. You can use these methods with ad-hoc queries. They can be used with parameters as well.

Example from our code of ExecuteScalar:

Code: Select all

            int storeId = Token.Instance.StoreId;
            Database database = Token.Instance.Database;
            DbCommand selectCommand = database.GetSqlStringCommand("SELECT COUNT(*) AS TotalRecords FROM ac_ErrorMessages WHERE StoreId = @storeId");
            database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, storeId);
            return CommerceBuilder.Utility.AlwaysConvert.ToInt(database.ExecuteScalar(selectCommand));

Hope this gets you pointed in the right direction.

[AbleOne]

Awesome Logan.. thank you for the quick response.

Will try and see if I run into any issues.

Thanks.
-sri
sri@awcs.net