public WorkerRecord UpdateWorker(WorkerRecord record, IDbTransaction transaction)
{
const string Sql =
@"UPDATE [BlueCollarWorker]
SET
[Name] = @Name,
[MachineName] = @MachineName,
[MachineAddress] = @MachineAddress,
[QueueNames] = @QueueNames,
[Status] = @StatusString,
[Signal] = @SignalString,
[Startup] = @StartupString,
[UpdatedOn] = @UpdatedOn
WHERE
[Id] = @Id;";
this.connection.Execute(
Sql,
record,
transaction,
null,
null);
return record;
}