private static void UpdateDatabaseSchema(NHibernate.Cfg.Configuration cfg, string connectionString)
{
MiniSessionManager.ExecuteScript(connectionString, @"
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'wf') EXEC('CREATE SCHEMA wf AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'security') EXEC('CREATE SCHEMA security AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'audit') EXEC('CREATE SCHEMA audit AUTHORIZATION [dbo]');" );
var updateCode = new System.Text.StringBuilder();
var schemaUpdate = new SchemaUpdate(cfg);
schemaUpdate.Execute(row =>
{
updateCode.AppendLine(row);
updateCode.AppendLine();
}, true);
}
public override void CreateSchemas()
{
MiniSessionManager.ExecuteScript(@"IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'wf') EXEC('CREATE SCHEMA wf AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'security') EXEC('CREATE SCHEMA security AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'audit') EXEC('CREATE SCHEMA audit AUTHORIZATION [dbo]');");
}
