G
Guest
In the database design I'm using a soft delete (a column flaged as IsDeleted)
instead of a hard delete, what should you do if the item is deleted in one
table yet you go a create a dropdownlist with a list of items and record you
bring up has that soft deleted item so you try to "set" the selected vaue to
it and it no longer is in the list since your sql statement looks for
IsDeleted = 0? You'll get an error not in the list anymore (not an item in
the list). You could Try/ Catch it. But is there a more common way to
prevent/avoid this?
Thanx.
instead of a hard delete, what should you do if the item is deleted in one
table yet you go a create a dropdownlist with a list of items and record you
bring up has that soft deleted item so you try to "set" the selected vaue to
it and it no longer is in the list since your sql statement looks for
IsDeleted = 0? You'll get an error not in the list anymore (not an item in
the list). You could Try/ Catch it. But is there a more common way to
prevent/avoid this?
Thanx.