How to manage history table if I want to delete a record from the main table? Thanks
One option is to use a soft-delete i.e. set IsEnabled = false
how do we then insert records into the original table and history table at same time? do we run insert query to insert into the 2 tables at same time?
You can run two distinctive inserts within the same transaction scope.
Begin transaction Insert into original-table Get inserted auto-id (optional) Insert into history-table Commit transaction
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
How to manage history table if I want to delete a record from the main table?
Thanks
One option is to use a soft-delete i.e. set IsEnabled = false
how do we then insert records into the original table and history table at same time? do we run insert query to insert into the 2 tables at same time?
You can run two distinctive inserts within the same transaction scope.