ASP .Net 2.0交易處理

最後更新：2018-12-07 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

系統比較複雜，更新多個表，所以需要使用交易處理
https://www.microsoft.com/china/msdn/library/webservices/asp.net/dnbdabdasamppet4.mspx?mfr=true

http://editblog.csdn.net/msdncolumn/archive/2005/02/25/1658.aspx

http://blog.joycode.com/kaneboy/archive/2005/02/15/44356.aspx 介紹最清楚System.Transactions

http://idior.cnblogs.com/archive/2005/08/15/214300.html 介紹最深入System.Transactions
Transaction Team Wiki
Florin Lazar's Blog
Jim Johnson's Blog
Angle Saenz-Badillos' Blog

http://www.15seconds.com/issue/040914.htm

public void TransactionTest()
        {
            string connectionString = "";
            IDbConnection connection = new SqlConnection(connectionString);
            connection.Open();
            IDbCommand command = new SqlCommand();
            command.Connection = connection;
            IDbTransaction transaction;
            transaction = connection.BeginTransaction(); //Enlisting database
            command.Transaction = transaction;
            try
            {
                /**//* Interact with database here, then commit the transaction
                */
                transaction.Commit();
            }
            catch
            {
                transaction.Rollback(); //Abort transaction
            }
            finally
            {
                connection.Close();
            }
        }

什麼是 System.Transactions？

System.Transactions 是 .NET 2.0 架構中新增的事務控制項命名空間。它是一種處理分散式交易的新方式，沒有 COM+ 註冊和 COM+ 目錄的開銷。請注意，Microsoft 分散式交易協調器用於初始化事務。

運行情況

同步定單處理中的 Order.Insert() 方法使用 System.Transactions 插入一個定單並更新庫存。通過添加對 System.Transaction 命名空間的引用，並將定單插入方法和庫存減少方法封裝在 TransactionScope 內，我們實現了 Order.Insert() 方法，如代碼清單 1 所示。

清單 1. 運行中的 System.Transactions

using System;using System.Transactions;using PetShop.IBLLStrategy;namespace PetShop.BLL {/// <summary>/// This is a synchronous implementation of IOrderStrategy/// By implementing IOrderStrategy interface, the developer can/// add a new order insert strategy without re-compiling the whole/// BLL./// </summary>public class OrderSynchronous : IOrderStrategy {.../// <summary>/// Inserts the order and updates the inventory stock within/// a transaction./// </summary>/// <param name="order">All information about the order</param>public void Insert(PetShop.Model.OrderInfo order) {using (TransactionScope ts = newTransactionScope(TransactionScopeOption.Required)) {dal.Insert(order);// Update the inventory to reflect the current inventory// after the order submission.Inventory inventory = new Inventory();inventory.TakeStock(order.LineItems);// Calling Complete commits the transaction.// Excluding this call by the end of TransactionScope's// scope will rollback the transaction.ts.Complete();}}}}

<%@Page Language="VB" Debug="True"%>
<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.OleDb" %>

<html>
<body>

<h2>Original DataSet that was read in from the database:</h2>
<asp:datagrid id="ShowMembersOriginal" runat="server"/>
<h2>DataSet after changes:</h2>
<asp:datagrid id="ShowMembersWorking" runat="server"/>

</body>
</html>

<script language="vb" runat="server">
Sub Page_Load()
 Dim strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\edward\Association.mdb"
 Dim strSelect = "SELECT * FROM Members"
 Dim objDataSet As New DataSet()
 Dim objConnect As New OleDbConnection(strConnect)
 Dim objDataAdapter As New OleDbDataAdapter(strSelect, objConnect)
 
 objDataAdapter.Fill(objDataSet, "TheMembers") 
 objDataSet.AcceptChanges()
 Dim objTable As DataTable = objDataSet.Tables("TheMembers")
 
 ShowMembersOriginal.DataSource = objTable.DefaultView
 ShowMembersOriginal.DataBind()

 objTable.Rows(0).Delete()
 objTable.Rows(1)("LastName") = "-NewLastName-"
 objTable.Rows(2).Delete()
 objTable.Rows(3).Delete()
 objTable.Rows(4)("Contributions") = "9999"
 objTable.Rows.RemoveAt(5)
 objTable.Rows(5)("FirstName") = "-NewFirstName-"

 Dim objValsArray(2) As Object
 objValsArray(0) = 0
 objValsArray(1) = "NewOneFirstName"
 objValsArray(2) = "NewOneLastName"
 objTable.Rows.Add(objValsArray)

 Dim objTransaction As OleDbTransaction
 Dim objCommandBuilder As New OleDbCommandBuilder(objDataAdapter)
 objDataAdapter.DeleteCommand = objCommandBuilder.GetDeleteCommand()
 objDataAdapter.InsertCommand = objCommandBuilder.GetInsertCommand()
 objDataAdapter.UpdateCommand = objCommandBuilder.GetUpdateCommand()

 objConnect.Open()
 objTransaction = objConnect.BeginTransaction()

 objDataAdapter.DeleteCommand.Transaction = objTransaction
 objDataAdapter.InsertCommand.Transaction = objTransaction
 objDataAdapter.UpdateCommand.Transaction = objTransaction

 objDataAdapter.Update(objDataSet, "TheMembers")
 
 ShowMembersWorking.DataSource = objTable.DefaultView
 ShowMembersWorking.DataBind()
 
 'objTransaction.Commit()
 objTransaction.RollBack()
 
End Sub
</script>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More