How to Handle Single Transaction,Commit, RollBack

Chaithra Ramaswamy

9y1.2kLearn iOS Programming

How to Handle Single Transaction,Commit, RollBack For multiple connections in ADO.net.

Actually I have Multi level Hierarchal Models like:

Class1{

List

}

Class2{

List

Class5

}

Class3{

List

}

Class4{

}

Class5{

}

Class6{

}

There are six different Data Tables in DataBase for each and every class. For that i written 6 different Stored procedures. Now i am trying to insert data , While inserting if Exception is occuring in Any one of the Child table, then transaction should RollBack the Resut. I am not getting How to do this. Please help me in this.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyaprakash Samantaray9y ago
https://www.codeproject.com/Articles/10223/Using-Transactions-in-ADO-NET
0
Tapan Patel9y ago
You need to surround your code with try catch block for each of the database operations in your methods and in order to rollback you can always use sqltransaction.begintransaction and sqltransaction.rollback methods.

Take a look at detailed example below:
http://www.c-sharpcorner.com/UploadFile/rohatash/performing-sql-server-transaction-using-ado-net/
0