protected virtual void Dispose(bool disposing) { if(!isDisposed) { if (disposing) { if (_trx != null) { _trx.Dispose(); _trx = null; } if (_conn != null) { _conn.Dispose(); _conn = null; } } } // Code to dispose the unmanaged resources // held by the class _trx = null; _conn = null; isDisposed = true; }
public void Commit() { #if (SQLDebug) System.Diagnostics.Debug.Write("Commit Transaction : "); #endif if (_trx == null) { _trxCnt = 0; return; } if (_trxCnt == 1)_trx.Transaction.Commit(); #if (SQLDebug) System.Diagnostics.Debug.Write(_trx.GetHashCode()); #endif if (_trxCnt > 0) _trxCnt--; if (_trxCnt < 1) _trx = null; }
public void Rollback() { #if (SQLDebug) System.Diagnostics.Debug.Write("Commit Transaction : "); #endif if (_trx == null) { _trxCnt = 0; return; } _trx.Transaction.Rollback(); #if (SQLDebug) System.Diagnostics.Debug.Write(_trx.GetHashCode()); #endif _trxCnt = 0; _trx = null; }
public DBTransaction BeginTransaction() { #if (SQLDebug) System.Diagnostics.Debug.Write("Begin Transaction : "); #endif if (_conn.State == System.Data.ConnectionState.Closed) _conn.Open(); if (_trx == null) _trx = new DBTransaction(_conn.BeginTransaction(), this); _trxCnt++; #if (SQLDebug) System.Diagnostics.Debug.WriteLine(_trx.GetHashCode()); #endif return _trx; }