Use of transactionscop transaction mechanism

If the transactionscope class (Distributed Transaction) is used in C #, note the following:
1. Reference The using system. Transactions namespace in the project (you must first Add a reference to the net component );

2. Example:

/// <Summary> /// send the message /// </Summary> /// <Param name = "senduserid"> </param> /// <Param name = "touser"> Format: 7ffa3af2-e74b-4154-8403-5010c53e49a7 | username, 7ffa3af2-e74b-4154-8403-5010c53e49a7 | username </param> /// <Param name = "content"> </param> /// <Param name = "sendedstatus"> indicates that the message is sent </param>/ // <returns> </returns> Public static int sendmessage (string senduserid, string touser, string content, string sendedstatus) {int receivecount = 0; transactionoptions transactionoption = new transactionoptions (); // sets the transaction isolation level transactionoption. isolationlevel = system. transactions. isolationlevel. readcommitted; // set the transaction timeout to 60 seconds transactionoption. timeout = new timespan (0, 0, 60); Using (transactionscope scope = new transactionscope (transactionscopeoption. required, transactionoption) {try {// here implement transactional work // send the message insertmessage (senduserid, touser, content, sendedstatus ); // Insert the record receivecount + = insertreceivemessage (userids [0], senduserid, content, "0") in the receiving information table; // No error occurs and the transaction scope is committed. complete ();} catch (exception ex) {Throw new exception ("sending information exception, cause:" + ex. message);} finally {// release the resource scope. dispose () ;}} return receivecount ;}

3. MSDTC component settings:
On the Control Panel ---> Administrative Tools ---> service, enable the Distributed Transaction Coordinator service.
A. Control Panel-> Administrative Tools-> component services-> Computer-> my computer-> right-click-> Properties
B. Select the MSDTC page and confirm "use local coordinator"
C. Click the "Security Configuration" button below
D. Select "allow network DTC Access", "allow remote clients", "Allow inbound", "Allow outbound", and "do not require authentication ".
E. For the database server, you can select "require verification to the caller"
F. Select "enable transaction Internet Protocol (TIP) transaction ".
G.add the msdtc.exe exception to the double fire wall
Command line available: netsh firewall set allowedprogram % WINDIR % \ system32 \ msdtc.exe MSDTC enable

4. Restart the IIS server.