How to manage nested transactions using TransactionScope () in ASP.net

Question

I created a transaction inside a transaction within the main transaction using

new TransactionScope(TransactionScopeOption.RequiresNew)

but my problem is that when the internal transaction is successfully completed, then if any error occurred during the execution, my complete transaction will not be completely rolled back,

means that my internal transaction records are in my database. but I want my complete rollback of transactions.

Help me if any solution exists for this kind of situation.

Answer 1

. Required, .