BlueCollar.SQLiteRepository.DeleteSchedule C# (CSharp) Метод

        public void DeleteSchedule(long id, IDbTransaction transaction)
        {
            const string Sql =
            @"UPDATE [BlueCollarQueue]
            SET
            [ScheduleId] = NULL
            WHERE
            [ScheduleId] = @Id;

            UPDATE [BlueCollarWorking]
            SET
            [ScheduleId] = NULL
            WHERE
            [ScheduleId] = @Id;

            UPDATE [BlueCollarHistory]
            SET
            [ScheduleId] = NULL
            WHERE
            [ScheduleId] = @Id;

            DELETE FROM [BlueCollarScheduledJob]
            WHERE
            [ScheduleId] = @Id;
            DELETE FROM [BlueCollarSchedule]
            WHERE
            [Id] = @Id;";

            this.connection.Execute(Sql, new { Id = id }, transaction, null, null);
        }