private static void EnsureDB(ISchemaHandler schemaHandler) { string script = null; if (schemaHandler.DatabaseExists()) { script = schemaHandler.CreateUpdateDDLScript(null); } else { schemaHandler.CreateDatabase(); script = schemaHandler.CreateDDLScript(); } if (!string.IsNullOrEmpty(script)) { schemaHandler.ExecuteDDLScript(script); } }
private static string GenerateScript(ISchemaHandler handler, TextWriter log) { string ddlScript = string.Empty; if (!handler.DatabaseExists()) { TryLogMessage(log, "Creating database script..."); ddlScript = handler.CreateDDLScript(); } else { TryLogMessage(log, "Database exists, creating migration script..."); ddlScript = handler.CreateUpdateDDLScript( new Telerik.OpenAccess.SchemaUpdateProperties()); } return(ddlScript); }
private static void EnsureDB(ISchemaHandler schemaHandler) { string script = null; if (schemaHandler.DatabaseExists()) { script = schemaHandler.CreateUpdateDDLScript(null); } else { schemaHandler.CreateDatabase(); script = schemaHandler.CreateDDLScript(); } if (!string.IsNullOrEmpty(script)) { schemaHandler.ExecuteDDLScript(script); } }
private static void ExecuteScript(string ddlScript, ISchemaHandler handler, TextWriter log) { if (!string.IsNullOrEmpty(ddlScript)) { if (!handler.DatabaseExists()) { TryLogMessage(log, "Database does not exist, creating database.."); handler.CreateDatabase(); } TryLogMessage(log, "Updating database schema..."); //This is the call that modifies the databaschema. Use with care. handler.ExecuteDDLScript(ddlScript); } else { TryLogMessage(log, "No changes to make."); } }
public void UpdateSchema() { ISchemaHandler schemaHandler = GetSchemaHandler(); string script = null; if (schemaHandler.DatabaseExists()) { script = schemaHandler.CreateUpdateDDLScript(null); } else { schemaHandler.CreateDatabase(); script = schemaHandler.CreateDDLScript(); } if (!string.IsNullOrEmpty(script)) { schemaHandler.ExecuteDDLScript(script); } }