public SACommand CreateAddProductCommand(SAConnection conn, SATransaction transaction)
        {
            var cmd = new SACommand(_sql, conn, transaction);
            CreateParameters(cmd);

            return cmd;
        }
示例#2
0
        /// <summary>
        /// Start a transaction
        /// </summary>
        public static bool CommitTransaction()
        {
            bool rc = false;

            try
            {
                if (_trans != null)
                {
                    _trans.Commit();
                    _trans.Dispose();
                    _trans = null;
                    rc     = true;
                }
                else
                {
                    throw (new Exception("Commit transaction before begin transaction."));
                }

                return(rc);
            }
            finally
            {
                Monitor.Exit(_translock);
            }
        }
示例#3
0
 public override void BeginTransaction()
 {
     if (_currentState != ConnectionState.Open)
     {
         Open();
     }
     _transaction = _connection.BeginTransaction();
 }
示例#4
0
 public override void BeginTransaction()
 {
     Logger.Info("Begin transaction " + _connectionString);
     if (_currentState != ConnectionState.Open)
     {
         Open();
     }
     _transaction = _connection.BeginTransaction();
 }
 /// <summary>
 /// Start a transaction
 /// </summary>
 public static bool BeginTransaction()
 {
     Monitor.Enter(_translock);
     if (_trans == null && conn.State == ConnectionState.Open)
     {
         _trans = conn.BeginTransaction();
         return true;
     }
     Monitor.Exit(_translock);
     return false;
 }
示例#6
0
 /// <summary>
 /// Start a transaction
 /// </summary>
 public static bool BeginTransaction()
 {
     Monitor.Enter(_translock);
     if (_trans == null && conn.State == ConnectionState.Open)
     {
         _trans = conn.BeginTransaction();
         return(true);
     }
     Monitor.Exit(_translock);
     return(false);
 }
 public void BeginTransaction()
 {
     if (_connection != null)
     {
         _transaction = _connection.BeginTransaction();
     }
     else
     {
         throw new InvalidOperationException("You must have a valid connection object before calling BeginTransaction.");
     }
 }
        public void Disconnect()
        {
            if ((_connection != null) && (_connection.State != ConnectionState.Closed))
            {
                _connection.Close();
            }

            if (_connection != null)
            {
                _connection.Dispose();
            }
            if (_transaction != null)
            {
                _transaction.Dispose();
            }

            _transaction = null;
            _connection  = null;
        }
        /// <summary>
        /// Start a transaction
        /// </summary>
        public static bool CommitTransaction()
        {
            bool rc = false;
            try
            {
                if (_trans != null)
                {
                    _trans.Commit();
                    _trans.Dispose();
                    _trans = null;
                    rc = true;
                }
                else
                {
                    throw (new Exception("Commit transaction before begin transaction."));
                }

                return rc;
            }
            finally
            {
                Monitor.Exit(_translock);
            }
        }