/// <summary>
/// Creates Sql configuration properties for the specified container suitable for passing to
/// <see cref="ITenantStore.UpdateTenantAsync(string, string?, IEnumerable{KeyValuePair{string, object}}?, IEnumerable{string}?)"/>.
/// </summary>
/// <param name="values">Existing configuration values to which to append these.</param>
/// <param name="definition">The definition of the Sql container for which to set the configuration.</param>
/// <param name="configuration">The configuration to set.</param>
/// <returns>
/// Properties to pass to
/// <see cref="ITenantStore.UpdateTenantAsync(string, string?, IEnumerable{KeyValuePair{string, object}}?, IEnumerable{string}?)"/>.
/// </returns>
public static IEnumerable <KeyValuePair <string, object> > AddSqlConfiguration(
this IEnumerable <KeyValuePair <string, object> > values,
SqlConnectionDefinition definition,
SqlConfiguration configuration)
{
ArgumentNullException.ThrowIfNull(values);
ArgumentNullException.ThrowIfNull(definition);
ArgumentNullException.ThrowIfNull(configuration);
return(values.Append(new KeyValuePair <string, object>(GetConfigurationKey(definition), configuration)));
}
/// <summary>
/// Get the configuration for the specified Sql container definition for a particular tenant.
/// </summary>
/// <param name="tenant">The tenant.</param>
/// <param name="definition">The Sql storage container definition.</param>
/// <returns>The configuration for the Sql account for this tenant.</returns>
public static SqlConfiguration GetSqlConfiguration(this ITenant tenant, SqlConnectionDefinition definition)
{
ArgumentNullException.ThrowIfNull(tenant);
ArgumentNullException.ThrowIfNull(definition);
// First, try the configuration specific to this instance
if (tenant.Properties.TryGet(GetConfigurationKey(definition), out SqlConfiguration? configuration))
{
return(configuration);
}
throw new ArgumentException($"No Sql configuration was found for connection definition with database name '{definition.Database}'");
}
private static string GetConfigurationKey(SqlConnectionDefinition definition)
{
return($"StorageConfiguration__{definition.Database}");
}
/// <summary>
/// Describes how to clear the Sql configuration for the specified container from tenant
/// properties in form suitable for passing as the <c>propertiesToRemove</c> argument to
/// <see cref="ITenantStore.UpdateTenantAsync(string, string?, IEnumerable{KeyValuePair{string, object}}?, IEnumerable{string}?)"/>.
/// </summary>
/// <param name="definition">The definition of the Sql container for which to clear the configuration.</param>
/// <returns>
/// A single-entry list of properties that can be passed to
/// <see cref="ITenantStore.UpdateTenantAsync(string, string?, IEnumerable{KeyValuePair{string, object}}?, IEnumerable{string}?)"/>
/// to remove the storage configuration.
/// </returns>
public static IEnumerable <string> RemoveSqlConfiguration(this SqlConnectionDefinition definition)
{
ArgumentNullException.ThrowIfNull(definition);
return(new string[] { GetConfigurationKey(definition) });
}
