/// <summary>
/// Generates the update statement for this table.
/// </summary>
/// <param name="context"></param>
/// <param name="queryBuilder"></param>
/// <param name="record"> </param>
/// <param name="modifiedProperties"></param>
protected override void DoToUpdateStatement(IMansionContext context, ModificationQueryBuilder queryBuilder, Record record, IPropertyBag modifiedProperties)
{
// create a table modification query
var tableModificationQuery = new ModificationQueryBuilder(queryBuilder);
foreach (var column in Columns)
column.ToUpdateStatement(context, tableModificationQuery, record, modifiedProperties);
// if there are no modified column add table modification query to the master query builder
if (tableModificationQuery.HasModifiedColumns)
queryBuilder.AppendQuery(tableModificationQuery.ToUpdateStatement(Name));
}