Transaction Control for addition, deletion, and modification across databases in C #

During program development, transactions are usually used to add, delete, and modify databases for all updates and rollback. A single database is relatively easy to do. If you need to operate multiple databases at the same time, you can use the following method

I. TransactionScope class

The TransactionScope class is a new class in framework2.0. in the Transactions namespace, you must first add System. transactions references. In addition, you need to go to the windows Control Panel and choose management tools> services> Distributed Transaction Coordinator> Properties> start to start the service. the sample code is as follows:

 

Code
Try
{
Using (TransactionScope scope = new TransactionScope ())
{
// Update the Employees table of the northwind database
Using (SqlConnection conOne = new SqlConnection ("server =.; uid = sa; pwd = 123; database = northwind "))
{
ConOne. Open ();

SqlCommand command = new SqlCommand ("update Employees set lastname = chen where employeeid = 1", conOne );
Int I = command. ExecuteNonQuery ();
}

// Update the jobs table of the pubs Database
Using (SqlConnection conTwo = new SqlConnection ("server =.; uid = sa; pwd = 123; database = pubs "))
{
ConTwo. Open ();
SqlCommand command = new SqlCommand ("update jobs set job_desc = chen where job_id = 1", conTwo );
Int I = command. ExecuteNonQuery ();
}

Scope. Complete (); // submit a transaction
}
}
Catch (Exception ex) // automatically rolls back when an Exception occurs