业务逻辑层实现事务处理

Code
private void customersBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
    UpdateData();
}

private void UpdateData()
{
    this.Validate();
    this.customersBindingSource.EndEdit();
    this.ordersBindingSource.EndEdit();

    using (System.Transactions.TransactionScope updateTransaction = 
        new System.Transactions.TransactionScope())
    {
        DeleteOrders();
        DeleteCustomers();
        AddNewCustomers();
        AddNewOrders();

        updateTransaction.Complete();
        northwindDataSet.AcceptChanges();
    }
}

The order for reconciling changes to related data is as follows:

• Delete child records (in this case, delete records from the Orders table)

• Delete parent records (in this case, delete records from the Customers table)

• Insert parent records (in this case, insert records in the Customers table)

• Insert child records (in this case, insert records in the Orders table)

作者：灵动生活 郝宪玮

出处：http://www.cnblogs.com/ywqu

如果你认为此文章有用，请点击底端的【推荐】让其他人也了解此文章，

本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。