ASP.NET Tutorial/ADO.net Database/TransactionScope

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>