public ScheduledJobRecord UpdateScheduledJob(ScheduledJobRecord record, IDbTransaction transaction) { const string Sql = @"UPDATE [BlueCollarScheduledJob] SET [Data] = @Data, [JobType] = @JobType WHERE [Id] = @Id;"; this.connection.Execute( Sql, record, transaction, null, null); return record; }