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();
}
