Assembly : CA.Blocks.DataAccess.dll
This class provides the abstract implementation for the Code Associate Data Access Block. The Abstract implementation is build upon utilizing common System.Data methods and interfacing out the Specific DBCommand using the IDbCommand interface. In doing this all specializations built on top of this class will behave in the same manor. This class is abstract and cannot be created.
|DataAccessCore(CA.Blocks.DataAccess.DI.IDataAccessConfig, CA.Blocks.DataAccess.Translator.DbRowToObject.Interfaces.IDbRowTranslatorProvider)||This is a protected constructor which must be called by the inheriting class, it will use config.Resolver to resolve the connectionStringKey to a valid connection string|
The WrapUp procedure is called when completing a database call. It will establish whether or not to close the connection pending the variable closeConnection which would have been passed back from the PrepCommand. The PrepCommand and WrapUp work in tandem when executing commands though this common class.
The Prep Command is abstract method that must be implemented by the providers. The method will create the the provider specific connection setting the connection string, Opening the connection, set any context on the connection the assign the connection to the command for execution, it will also and indicate to the blocks if the connection should be closed on complete execution. In most cases it is best to close the connection, at the provider will managed the connection pool.
Will execute a value sql query that does not return any results back to the client. This is typically Data modification statements such as insert , update or delete or catalog operations such as creating tables, indexes etc
Executes the command into a new Dataset
|ExecuteDataSet(System.Data.IDbCommand, System.Data.DataSet, System.String)|
This will execute the cmd to a ScalarValue and convert the ScalarValue to string value, There is a overload top control the value of the null passed back.