public async Task<string> GetAsync(SettingKey settingKey, SettingGroupKey settingGroupKey, CancellationToken cancellationToken)
{
var values = await _msSqlConnection.QueryAsync<string>(
cancellationToken,
GetSql,
new {Key = settingKey.Value, GroupKey = settingGroupKey.Value })
.ConfigureAwait(false);
return values.SingleOrDefault();
}
public async Task<IReadOnlyCollection<SettingGroupKey>> GetKeysAsync(SettingGroupKey settingGroupKey, CancellationToken cancellationToken)
{
var keys = await _msSqlConnection.QueryAsync<string>(
cancellationToken,
ListSql,
new {GroupKey = settingGroupKey.Value})
.ConfigureAwait(false);
return keys
.Select(SettingGroupKey.With)
.ToList();
}
public async Task SetAsync(SettingKey settingKey, SettingGroupKey settingGroupKey, string value, CancellationToken cancellationToken)
{
if (string.IsNullOrEmpty(value)) throw new ArgumentNullException(nameof(value));
var affectedRows = await _msSqlConnection.ExecuteAsync(
cancellationToken,
SetSql,
new {Key = settingKey.Value, Value = value, GroupKey = settingGroupKey.Value})
.ConfigureAwait(false);
if (affectedRows != 1)
{
throw new Exception($"Updating key '{settingKey}' didn't update any rows");
}
}
public Task RemoveAsync(SettingKey settingKey, SettingGroupKey settingGroupKey, CancellationToken cancellationToken)
{
return _msSqlConnection.ExecuteAsync(
cancellationToken,
DeleteSql,
new {Key = settingKey.Value, GroupKey = settingGroupKey.Value });
}
