In C# using BeginTransaction,CommitTransaction and Rollback

Question

In SQL Using Stored Procedure (Begin,Commit,Rollback Transaction)

 

In C# ,Not using Procedure only sql query using the same process begin transaction,commit Transaction and Rollback Transaction how to perform

 

---Examples code...