public override void Dispose()
        {
            Transaction?.Dispose();

            if (_deleteDatabase)
            {
                _connection.Drop(throwOnOpen: false);
            }
            Connection?.Dispose();
            base.Dispose();
        }