How to handle Transaction in C# Code as well as Store Proc

Question

We want to insert record in multiple databases then how to handle Transaction in C# Code as well as Store Procedure?

Manas Mohapatra · Answer

In C# code: Use the TransactionScope class using (TransactionScope ts = new TransactionScope()) { //all db code here // if an error occurs jump out of the using block and it will dispose and rollback ts.Co mplete(); } If you want to do in Stored Procedure side then use BEGIN TRANSACTION statement. A transaction across multiple DBs in the same instance is a local transaction. http://www.c-sharpcorner.com/article/transaction-in-net/