/// <summary>
/// Scripts the database objects creation for storing IdentityServer data.
/// </summary>
/// <param name="scriptFileName">Output file name</param>
/// <param name="configuration">NHibernate Configuration object that represents the database configuration to script.</param>
/// <param name="configurationStoreOptions">Options for configuration store.</param>
/// <param name="operationalStoreOptions">Options for operational store.</param>
/// <remarks>
/// Configuration store options and operational store options are needed to detect the schema for each database object.
/// </remarks>
public static void CreateSchemaScriptForDatabase(
string scriptFileName,
Configuration configuration,
ConfigurationStoreOptions configurationStoreOptions,
OperationalStoreOptions operationalStoreOptions)
{
if (configurationStoreOptions == null)
{
throw new ArgumentNullException(nameof(configurationStoreOptions));
}
if (operationalStoreOptions == null)
{
throw new ArgumentNullException(nameof(operationalStoreOptions));
}
configuration.AddConfigurationStoreMappings(configurationStoreOptions);
configuration.AddOperationalStoreMappings(operationalStoreOptions);
var dialect = Dialect.GetDialect(configuration.Properties);
SchemaMetadataUpdater.QuoteTableAndColumns(configuration, dialect);
new SchemaExport(configuration)
.SetOutputFile(scriptFileName)
.SetDelimiter(";")
.Execute(true, false, false);
}
/// <summary>
/// Scripts the database objects creation for storing IdentityServer data.
/// </summary>
/// <param name="scriptFileName">Output file name</param>
/// <param name="configuration">NHibernate Configuration object that represents the database configuration to script.</param>
/// <param name="configurationStoreOptions">Options for configuration store.</param>
/// <param name="operationalStoreOptions">Options for operational store.</param>
/// <remarks>
/// Configuration store options and operational store options are needed to detect the schema for each database object.
/// </remarks>
public static void CreateSchemaScriptForDatabase(
string scriptFileName,
Configuration configuration,
ConfigurationStoreOptions configurationStoreOptions,
OperationalStoreOptions operationalStoreOptions)
{
if (configurationStoreOptions == null)
{
throw new ArgumentNullException(nameof(configurationStoreOptions));
}
if (operationalStoreOptions == null)
{
throw new ArgumentNullException(nameof(operationalStoreOptions));
}
configuration.AddConfigurationStoreMappings(configurationStoreOptions);
configuration.AddOperationalStoreMappings(operationalStoreOptions);
new SchemaExport(configuration)
.SetOutputFile(scriptFileName)
.Execute(true, false, false);
}
