SQLCLRでのトランザクション

Sqlconnection connection1 = new Sqlconnection(サーバへの接続文字列);

Sqlconnection connection2 = new Sqlconnection(上と同じ接続文字列);



connection1.Open();

connection2.Open();



SqlTransaction tran1 = connection1.BeginTransaction();

SqlTransaction tran2 = connection2.BeginTransaction();



SqlCommand command1 = new SqlCommand();

command1.Connection = connection1;

command1.Transaction = tran1;



SqlCommand command2 = new SqlCommand();

command2.Connection = connection2;

command2.Transaction = tran2;



try

{

    for(int i = 0;i < 10; i++)

    {

         SqlCommandを使い何らかの処理を行う。

    }

    tran1.Commit();

}

catch

{

    tran1.RollBack();

}

tran2.Commit();



connection1.Close();

connection2.Close();