C# (CSharp) ML.AccessControl.DAL.SQLServer DBTransaction Examples

Example #1

File: DBManager.cs Project: abdojobs/ml-access-control-dotnet

 public override AbsTransaction BeginTransaction()
 {
     if (_transaction != null && !_transaction.IsDisposed)
         throw new Exception("Transaction already in progress");
     SqlConnection cnn = new SqlConnection(_sConnectionString);
     cnn.Open();
     _transaction = new DBTransaction(cnn.BeginTransaction());
     return _transaction;
 }

Example #2

        public override AbsTransaction BeginTransaction()
        {
            if (_transaction != null && !_transaction.IsDisposed)
            {
                throw new Exception("Transaction already in progress");
            }
            SqlConnection cnn = new SqlConnection(_sConnectionString);

            cnn.Open();
            _transaction = new DBTransaction(cnn.BeginTransaction());
            return(_transaction);
        }

Example #3

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 public void Dispose()
 {
     if (!_bIsDisposed)
     {
         if (_transaction == null || _transaction.IsDisposed)
         {
             if (_connection != null && _connection.State != System.Data.ConnectionState.Closed)
                 _connection.Close();
         }
         _connection = null;
         _transaction = null;
         _bIsDisposed = true;
     }
 }

Example #4

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 public void Dispose()
 {
     if (!_bIsDisposed)
     {
         if (_transaction == null || _transaction.IsDisposed)
         {
             if (_connection != null && _connection.State != System.Data.ConnectionState.Closed)
             {
                 _connection.Close();
             }
         }
         _connection  = null;
         _transaction = null;
         _bIsDisposed = true;
     }
 }

Example #5

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 internal ConnectionWrapper(DBTransaction pTransaction)
 {
     _connection  = pTransaction.InnerTransaction.Connection;
     _transaction = pTransaction;
 }

Example #6

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 internal ConnectionWrapper(SqlConnection pConnection)
 {
     _connection  = pConnection;
     _transaction = null;
 }

Example #7

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 internal ConnectionWrapper(DBTransaction pTransaction)
 {
     _connection = pTransaction.InnerTransaction.Connection;
     _transaction = pTransaction;
 }

Example #8

File: ConnectionWrapper.cs Project: abdojobs/ml-access-control-dotnet

 internal ConnectionWrapper(SqlConnection pConnection)
 {
     _connection = pConnection;
     _transaction = null;
 }