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