public void BeginTransaction(IsolationLevel isolationLevel) { OpenConnection(); _logger.LogDebug("BeginTransaction."); Transaction = Connection.BeginTransaction(isolationLevel); LifeCycle = DbSessionLifeCycle.Scoped; }
public void RollbackTransaction() { if (_logger.IsEnabled(LogLevel.Debug)) { _logger.LogDebug("RollbackTransaction ."); } if (Transaction == null) { if (_logger.IsEnabled(LogLevel.Error)) { _logger.LogError("Before RollbackTransaction,Please BeginTransaction first!"); } throw new SmartSqlException("Before RollbackTransaction,Please BeginTransaction first!"); } try { Transaction.Rollback(); Transaction.Dispose(); } catch (Exception ex) { _logger.LogError(new EventId(ex.HResult), ex, ex.Message); throw ex; } finally { Transaction = null; LifeCycle = DbSessionLifeCycle.Transient; CloseConnection(); } }
public DbConnectionSession(DbProviderFactory dbProviderFactory, IDataSource dataSource) { Id = Guid.NewGuid(); LifeCycle = DbSessionLifeCycle.Transient; DbProviderFactory = dbProviderFactory; DataSource = dataSource; }
public DbConnectionSession(ILoggerFactory loggerFactory, DbProviderFactory dbProviderFactory, IDataSource dataSource) { _logger = loggerFactory.CreateLogger <DbConnectionSession>(); Id = Guid.NewGuid(); LifeCycle = DbSessionLifeCycle.Transient; DbProviderFactory = dbProviderFactory; DataSource = dataSource; }
public void BeginTransaction() { OpenConnection(); _logger.Debug("DbConnectionSession.BeginTransaction."); Transaction = Connection.BeginTransaction(); LifeCycle = DbSessionLifeCycle.Scoped; }
public void CommitTransaction() { _logger.LogDebug("CommitTransaction."); Transaction.Commit(); Transaction.Dispose(); Transaction = null; LifeCycle = DbSessionLifeCycle.Transient; this.CloseConnection(); }
public void RollbackTransaction() { _logger.LogDebug("RollbackTransaction ."); Transaction.Rollback(); Transaction.Dispose(); Transaction = null; LifeCycle = DbSessionLifeCycle.Transient; this.CloseConnection(); }
public void End() { if (_logger.IsEnabled(LogLevel.Debug)) { _logger.LogDebug("End ."); } LifeCycle = DbSessionLifeCycle.Transient; CloseConnection(); }
public void Begin() { if (_logger.IsEnabled(LogLevel.Debug)) { _logger.LogDebug("Begin ."); } LifeCycle = DbSessionLifeCycle.Scoped; OpenConnection(); }
public void BeginTransaction(IsolationLevel isolationLevel) { if (_logger.IsEnabled(LogLevel.Debug)) { _logger.LogDebug("BeginTransaction."); } OpenConnection(); Transaction = Connection.BeginTransaction(isolationLevel); LifeCycle = DbSessionLifeCycle.Scoped; }
public void CommitTransaction() { if (_logger.IsEnabled(LogLevel.Debug)) { _logger.LogDebug("CommitTransaction."); } if (Transaction == null) { if (_logger.IsEnabled(LogLevel.Error)) { _logger.LogError("Before CommitTransaction,Please BeginTransaction first!"); } throw new SmartSqlException("Before CommitTransaction,Please BeginTransaction first!"); } Transaction.Commit(); Transaction.Dispose(); Transaction = null; LifeCycle = DbSessionLifeCycle.Transient; CloseConnection(); }