How to check if Dotnet transaction is rolled back?
How Can I c开发者_开发问答heck if a dotnet transaction is closed or not ?
Your title asks one thing and your question asks another. so, I am going with your title.
If you want to know if the transaction is rolled back or set to rollback only, you can check
transaction.WasRolledBack // true if transaction is rolled back
Here, transaction
is an instance of ITransaction
Edit (based on your comment):
var isRolledBack = false;
using (var connection = new SqlConnection())
{
using (var transaction = connection.BeginTransaction())
{
try
{
// do your stuff here with transaction
}
catch (Exception ex)
{
transaction.Rollback();
isRolledBack = true;
throw;
}
}
}
Now, you can check the isRolledBack
flag to see if the transaction is rolled back
using(TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew)){
try{
//Do something;
scope.Complete(); //denotes the transaction completed successful.
}
catch(TransactionAbortedException ex)
{
//scope.Complete(); is never called, the transaction rolls back automatically.
}
catch(ApplicationException ex)
{
}
}
If you are on SQL server, you can use DBCC OPENTRAN
http://msdn.microsoft.com/en-us/library/ms182792.aspx
精彩评论