public SACommand CreateAddProductCommand(SAConnection conn, SATransaction transaction) { var cmd = new SACommand(_sql, conn, transaction); CreateParameters(cmd); return cmd; }
/// <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); } }
public override void BeginTransaction() { if (_currentState != ConnectionState.Open) { Open(); } _transaction = _connection.BeginTransaction(); }
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; }
/// <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); } }