public void BeginTransaction()
        {
            if (_connection.State != ConnectionState.Open)
            {
                _connection.Open();
            }

            if (_transaction == null)
            {
                _transaction = _connection.BeginTransaction(IsolationLevel.ReadCommitted);
            }

            if (_transactionLifetime == null)
            {
                _transactionLifetime = _transaction.InitializeLifetimeService();
            }
        }