开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜