ASP.NET Tutorial/ADO.net Database/TransactionScope
Distributed Transaction
<source lang="csharp">
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="DistributedTransaction" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">
<title>Untitled Page</title>
</head> <body>
<form id="form1" runat="server">
</form>
</body> </html> File: Default.aspx.cs using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Data.OleDb; using System.Transactions; public partial class DistributedTransaction : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) { string connStrngA = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; string connStrngB = ConfigurationManager.ConnectionStrings["pub"].ConnectionString; bool isConsistant = false; using (TransactionScope scope = new TransactionScope()) { using (SqlConnection connA = new SqlConnection(connStrngA)) { } using (SqlConnection connB = new SqlConnection(connStrngB)) { isConsistant = true; } if (isConsistant) scope.ruplete(); } }
}</source>