Is there any commonly referred methodology or a kind of design-pattern or a model when it comes to delete a record from user interface which exists in a database?
Basically what following steps should be taken and when (like validation, deleting the main record, how to handle when there is a
Conflict with the REFERENCE constraint
How to handle exceptions or notifying user on a failure (how to transfer the BL failure info to the UI; by catching exceptions or some report object etc.) and more or less the most common issues regarding to the deletion context.
When you delete a record, you can do a few things:
What are you using for your business layer, and what API's are you using to retreive and store data in your code?