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(); } } } }