How to use Update.Table in 4.50.x?

// Add an external ID as nullable
Alter.Table("YourTableNameHere")
    .AddColumn("ExternalId")
    .AsInt32().Nullable();

// Populate the ID with required values
Execute.Sql("UPDATE YourTableNameHere SET ExternalId = 123 WHERE YourConditionHere");

// Set the external ID as non-nullable and add a foreign key
Alter.Table("YourTableNameHere")
    .AlterColumn("ExternalId")
    .AsInt32().NotNullable()
    .ForeignKey("FK_YourTableNameHere_ExternalId", "YourReferenceTableNameHere", "YourReferenceIdColumnNameHere");

Execute.Sql("UPDATE YourTableNameHere SET ExternalId = 123 WHERE YourConditionHere");

await _nopDataProvider.ExecuteNonQueryAsync(""UPDATE YourTableNameHere SET ExternalId = 123 WHERE YourConditionHere;");