Tutorial :SQL delete operations not rolled back



Question:

When I rollback a transaction it rollbacked only update and insert operations, but delete operations are not rollbacked, I want to know the reason?

I am using insert, update and delete operations under one SQL transaction


Solution:1

That doesn't sound correct. Examine your code and make sure that you are doing everything correctly or paste the important parts here.


Solution:2

All your CRUD operations on the same transaction should be rolled back. Period. Have you double-checked that you are using the transaction? It is impossible to diagnose just from your description; but believe me: somebody would have noticed before now...

Such things become a lot easier with TransactionScope, where enlisting is automatic.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »