Hello,

I am trying to add columns to a table and then update the current rows inside the same table. I found the Update expression but I can't seem to find how to tell it which column to update. You can see the migration below where I want to update the 'SentInvoice' column of table 'Order'.

public class MigrationAddedStartDateTrainingToOrder : MigrationBase
{
    public MigrationAddedStartDateTrainingToOrder(IMigrationContext context)
        : base(context)
    {

    }

    public override void Migrate()
    {
        if (!ColumnExists("Order", "StartDateTraining"))
        {
            Create.Column("StartDateTraining").OnTable("Order").AsDateTime().Nullable().WithDefaultValue(null).Do();
            Create.Column("SentInvoice").OnTable("Order").AsDateTime().Nullable().WithDefaultValue(null).Do();

            // Update Order SentInvoice
            Update.Table("Order").Set(DateTime.Now).AllRows().Do();
        }
    }
}

Does anyone know how to declare the column which should be updated?