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

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.