public static void GenerateSchema(NHibernate.Cfg.Configuration cfg, ISession session)
{
var dialect = Dialect.GetDialect(cfg.Properties);
var drops = cfg.GenerateDropSchemaScript(dialect);
ExecuteSqlScripts(drops, session);
var scripts = cfg.GenerateSchemaCreationScript(dialect);
ExecuteSqlScripts(scripts, session);
}
// Create database schema
private static void ReCreateSchema(NHibernate.Cfg.Configuration cfg)
{
Dialect dialect = Dialect.GetDialect(cfg.Properties);
using (var conn = new SqlConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString)))
{
conn.Open();
foreach (string cmdText in cfg.GenerateDropSchemaScript(dialect).Union(cfg.GenerateSchemaCreationScript(dialect)))
{
using (var cmd = new SqlCommand(cmdText, conn))
{
cmd.ExecuteNonQuery();
}
}
}
}
