private void buttonRevertSchema_Click(object sender, RoutedEventArgs e)
{
Db2SourceContext ctx = Target.Context;
ctx.Revert(Target);
IsEditing = false;
}
private void buttonApplySchema_Click(object sender, RoutedEventArgs e)
{
Db2SourceContext ctx = Target.Context;
List <string> sqls = new List <string>();
if ((Target.Comment != null) && Target.Comment.IsModified())
{
sqls.AddRange(ctx.GetSQL(Target.Comment, string.Empty, string.Empty, 0, false));
}
for (int i = 0; i < Target.Columns.Count; i++)
{
Column newC = Target.Columns[i, false];
if (newC.IsModified())
{
Column oldC = Target.Columns[i, true];
sqls.AddRange(ctx.GetAlterColumnSQL(newC, oldC));
}
if ((newC.Comment != null) && newC.Comment.IsModified())
{
sqls.AddRange(ctx.GetSQL(newC.Comment, string.Empty, string.Empty, 0, false));
}
}
if (sqls.Count != 0)
{
ctx.ExecSqlsWithLog(sqls);
}
ctx.Revert(Target);
IsEditing = false;
}
