public List<string> GenerateAddColumnStatement(AddColumn addColumn)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("ALTER TABLE {0} ADD COLUMN {1} {2} {3}", addColumn.Table, addColumn.Name, addColumn.DataType, addColumn.Nullable ? "NULL" : "NOT NULL");
return new List<string>() { sb.ToString() };
}
private IStatement ParseAddColumnStatement(XmlNode statement)
{
AddColumn addStatement = new AddColumn();
addStatement.Table = statement.Attributes["Table"].Value;
addStatement.Name = statement.Attributes["Name"].Value;
addStatement.DataType = statement.Attributes["DataType"].Value;
addStatement.Nullable = Convert.ToBoolean(statement.Attributes["Nullable"].Value);
addStatement.Default = statement.Attributes["Default"].Value;
return addStatement;
}