What is the best way to implement secure data management?

Question

ASP.NET

The data access layer in my application is split into many modules. Each module is responsible for a specific set of entities.
In the code that describes the application logic, there will sometimes be situations where you will work with several modules of the data layer. How to be in those cases when it is necessary to perform several operations with data sequentially? Suppose I add entity 1 (module A), then 2 (module B) and 3 (module C). What is the best way to rollback if an error occurred while adding an entity? Data layer modules can store data in different databases.

Answer 1

You didn't specify what type of database you have. Maybe MS DTC will be enough for you