Restoring repeater soft delete
TLDR:
Is it possible to make it so that adding new repeater elements will recycle soft deleted rows in a pivot table first? Or would it fundamentally be a bad idea for a repeater to recycle soft deleted rows?
Background:
My app is setup so that everything is soft-deleted and referenced by shadow tables for data history and recovery. The only place where I'm concerned with my implementation is in the pivot tables for many-to-many relationships. The soft delete and shadow table all works, but if data is deleted, and then new elements are added to the repeater, it's added as new rows in the pivot table. This leads to a situation where I can accumulate a bunch of dead rows in the data, and makes developing a way to explore the history and restore an old state more difficult. It seems like ideally I would want to recycle soft-deleted rows first before creating new ones.
Is it possible to make it so that adding new repeater elements will recycle soft deleted rows in a pivot table first? Or would it fundamentally be a bad idea for a repeater to recycle soft deleted rows?
Background:
My app is setup so that everything is soft-deleted and referenced by shadow tables for data history and recovery. The only place where I'm concerned with my implementation is in the pivot tables for many-to-many relationships. The soft delete and shadow table all works, but if data is deleted, and then new elements are added to the repeater, it's added as new rows in the pivot table. This leads to a situation where I can accumulate a bunch of dead rows in the data, and makes developing a way to explore the history and restore an old state more difficult. It seems like ideally I would want to recycle soft-deleted rows first before creating new ones.
