CODEWITHSUNDEEP
c#transactionscope
Orson
Orson

Reputation: 15451

Will an inner transaction scope roll back if the outer transaction scope doesn't complete?

I have two transaction scopes, one within another. I would love to know if the inner transaction scope will be rolled back after it has been committed and the outer one does not complete.

Upvotes: 64

Views: 32256

Answers (3)

Gaurav Basnet
Gaurav Basnet

Reputation: 86

Yes it will, you can refer to code below. The following code will roll back outer transaction scope if inner transaction throw error and vice versa.

public bool rootMethod()
{
  using (var transaction = new 
     TransactionScope(TransactionScopeOption.RequiresNew))
    try
    {
        // your code here
        SomeController someController = new SomeController();
        var responseFromChildMethod = 
        someController.childMethodWithTxn();

        // your logic here

        transaction.Complete();
        return true;
    }
    catch (Exception ex)
    {
        transaction.Dispose();
        return false;
    }
}

SomeController.cs

public bool childMethodWithTxn(){
  using(var newTransaction =  new TransactionScope()){
    try
    {
      // your code here
      newTransaction.Complete();
      return true;
    }
    catch(Exception ex){
           newTransaction.Dispose();
           return false;
           }

  }
}

Upvotes: 1

Greg Beech
Greg Beech

Reputation: 136717

It depends on the scope option you start the nested transaction scope with.

If you use the default option TransactionScopeOption.Required then the nested scope will enlist in the same transaction as the outer scope and as such when the outer scope rolls back the inner scope will also be rolled back even if it has called Complete.

If, however, you use TransactionScopeOption.RequiresNew then the nested scope will begin its own transaction and complete it separately from the outer scope, so it will not roll back even if the outer scope rolls back.

If you use TransactionScopeOption.Suppress then the nested scope will not take part in the outer transaction and will complete non-transactionally, thus does not form part of the work that would be rolled back if the outer transaction rolls back.

Upvotes: 141

Oded
Oded

Reputation: 499202

Since they are nested, the inner transaction will roll back.

This is not the whole story, and depends on how you create the nested transaction, but by default, it will roll back.

This article goes into depth about TransactionScope and should answer most of your questions.

Being distributed or not is irrelevant.

Upvotes: 34

Related Questions