can anyone suggest how do we implement multiple transactions in one service with same connection.
- first call procedure
- Insert in to Table
- call another Procedure
can some one tell me the best way to use three transactions, for every operation i need one transaction boudary.
One failure should not affet other operation…
How would be the solution…like 3 start transactions and 3 commit transactions and only one rollback…?? please suggest the way to achive it