/// <summary>
/// Updates the schema.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ButtonUpdateSchema_Click(object sender, EventArgs e)
{
var database = new BaseStationDatabase()
{
ConnectionString = Options.ConnectionString,
CanUpdateSchema = true,
};
var scriptOutput = database.UpdateSchema();
MessageBox.Show(String.Join(Environment.NewLine, scriptOutput), SqlServerStrings.SchemaUpdatedTitle);
}
/// <summary>
/// Updates the schema using the connection details passed across and returns an array of output lines from the update script.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="timeoutSeconds"></param>
/// <returns></returns>
public string[] UpdateSchema(string connectionString, int timeoutSeconds)
{
var database = new BaseStationDatabase()
{
ConnectionString = connectionString,
CommandTimeoutSeconds = timeoutSeconds,
CanUpdateSchema = true,
};
var scriptOutput = database.UpdateSchema();
return(scriptOutput);
}
/// <summary>
/// Updates the schema using the connection details passed across and returns an array of output lines from the update script.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="timeoutSeconds"></param>
/// <returns></returns>
public string[] UpdateSchema(string connectionString, int timeoutSeconds)
{
var database = new BaseStationDatabase()
{
ConnectionString = connectionString,
CommandTimeoutSeconds = timeoutSeconds,
CanUpdateSchema = true,
};
var scriptOutput = database.UpdateSchema();
if (scriptOutput == null ||
scriptOutput.Length == 0 ||
(scriptOutput.Length == 1 && String.IsNullOrEmpty(scriptOutput[0]))
)
{
scriptOutput = new string[] { SqlServerStrings.SchemaUpdateFailed };
}
return(scriptOutput);
}