Transactionscope with multiple Storedprocedures

Question

I’m thinking of implementing TransactionScope in my code, however, all bank access is made by StoredProcedures.

The TransactionScope can give rollback in multiple actions carried out in StoredProcedures?

using (var trans = new TransactionScope()) {
  try {
    this.Teste1Repository.Insert(); //  Chamada a primeira PROC
    this.Teste2Repository.Insert(); //  Chamada a segunda PROC

    trans.Complete();
  }
  catch {
  //  Trata erro
  }
}

Answer 1

If the first Storedprocedure SP1 issues a commit, the changes that have already been made will be permanent. In this case, if SP2 fails, the changes made by SP1 will not be reversed.

Either you control your system operations via Code, or via Database.

If you want to control the Rollbacks via code, you will have to rewrite the entire Procedure function to C#.

Source: Our own experience.

EDIT 1: Test this concept using Sqlcommand of the C#. https://stackoverflow.com/a/18718722/6579651