public void UpdateDataBaseSchema()
{
ISchemaHandler handler = this.GetSchemaHandler();
string script = null;
try
{
script = handler.CreateUpdateDDLScript(null);
}
catch
{
bool throwException = false;
try
{
handler.CreateDatabase();
script = handler.CreateDDLScript();
}
catch
{
throwException = true;
}
if (throwException)
{
throw;
}
}
if (string.IsNullOrEmpty(script) == false)
{
handler.ExecuteDDLScript(script);
}
}
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 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);
}
}