BlueCollar.SQLiteRepository.UpdateWorking C# (CSharp) Method

        public WorkingRecord UpdateWorking(WorkingRecord record, IDbTransaction transaction)
        {
            const string Sql =
            @"UPDATE [BlueCollarWorking]
            SET
            [WorkerId] = @WorkerId,
            [ScheduleId] = @ScheduleId,
            [QueueName] = @QueueName,
            [JobName] = @JobName,
            [JobType] = @JobType,
            [Data] = @Data,
            [QueuedOn] = @QueuedOn,
            [TryNumber] = @TryNumber,
            [StartedOn] = @StartedOn,
            [Signal] = @Signal
            WHERE
            [Id] = @Id;";

            this.connection.Execute(
                Sql,
                record,
                transaction,
                null,
                null);

            return record;
        }