title: ADO .NET transaction scope locks transaction even after stopped
body: <p>I have implemented transaction scope in a Web API application. It works fine when i have to commit all or rollback all. But sometimes while debugging, if i stop the service before transaction is completed, then the transaction is getting locked. The table is still showing as locked and that particular session remains in database even after closing the visual studio. This happens sometime and that partcular transaction is not getting rolledback. I have also set timeout for the transactionscope. Still the issue  is happening. Is there anyway to abort the table operation immediately after the servce is stopped inbetween?</p>