Will an inner transaction scope roll back if the outer transaction scope doesn't complete?
I have two transaction scopes, one within ano开发者_Python百科ther. 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.
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.
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.
Yes it will, you can refer to code below. Following code wil roll back outer transaction scope if inner transaction throw error and vice versa.
public bool rootMethod(){
using (var transaction = new(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;
}
}
}
精彩评论