Tutorial :SQL delete operations not rolled back


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


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


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
Next Post »