public void BeginTransaction()
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
if (_transaction == null)
{
_transaction = _connection.BeginTransaction(IsolationLevel.ReadCommitted);
}
if (_transactionLifetime == null)
{
_transactionLifetime = _transaction.InitializeLifetimeService();
}
}