protected override void Dispose(bool disposing) { if (disposing) { if (_transaction != null) _transaction.Dispose(); _connection.Close(); } }