Protocol.Covington.WorkRequest.IDAL.ConnectionProvider Class
Purpose: provides a SqlConnection object which can be shared among data-access tier objects to provide a way to do ADO.NET transaction coding without the hassling with SqlConnection objects on a high level.

Access: Public
Base Classes: Object
Implemented interfaces: IDisposable
  Members Description  
    _dBConnection    
    _isTransactionPending    
    _isDisposed    
    _currentTransaction    
    _savePoints    
    ConnectionProvider    
    Dispose Purpose: Implements the IDispose' method Dispose.

 
    Dispose Purpose: Implements the Dispose functionality.

 
    InitClass Purpose: Initializes class members.

 
    OpenConnection Purpose: opens the connection object.

 
    BeginTransaction Purpose: starts a new ADO.NET transaction using the open connection object of this class.

 
    CommitTransaction Purpose: commits a pending transaction on the open connection object of this class.

 
    RollbackTransaction Purpose: rolls back a pending transaction on the open connection object of this class, or rolls back to the savepoint with the given name. Savepoints are created with SaveTransaction().

 
    SaveTransaction Purpose: Saves a pending transaction on the open connection object of this class to a 'savepoint' with the given name. When a rollback is issued, the caller can rollback to this savepoint or roll back the complete transaction.

 
    CloseConnection Purpose: Closes the open connection. Depending on bCommitPendingTransactions, a pending transaction is commited, or aborted.

 
    CurrentTransaction    
    IsTransactionPending    
    DBConnection