public DbHelperScope(DataStorageSettings settings)
        {
            settings.ThrowIfNull(nameof(settings));
            settings.DbConnectionString.ThrowIfNull(nameof(settings.DbConnectionString));

            try
            {
                _connection = new SqlConnection(settings.DbConnectionString);
                _connection.Open();
                _transaction = _connection.BeginTransaction();
            }
            catch (Exception ex)
            {
                Dispose();
                _logger.Error(ex, "Exception occurred during connection to database.");
                throw;
            }
        }