Linq to sql中如何使用一个统一事务保存级联表格

需要使用到DataContext的嵌套

 

服务代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Linq;
using System.Configuration;

namespace CsharpTrainer.Linq.Service.Northwind
{
     public  class CascadeTableService
    {
         public  bool AddCascadeTables(CascadeA tableA, List<CascadeB> tablesB, List<CascadeC> tablesC)
        {
             bool result;
            
             try
            {
                 using (DataContext context =  new DataContext(ConfigurationManager.ConnectionStrings[ " NorthwindConnStr "].ToString()))
                {
                     using (NorthwindDBDataContext northwindContext =  new NorthwindDBDataContext())
                    {
                        northwindContext.CascadeA.InsertOnSubmit(tableA);
                        northwindContext.CascadeB.InsertAllOnSubmit(tablesB);
                        northwindContext.CascadeC.InsertAllOnSubmit(tablesC);

                        northwindContext.SubmitChanges();
                    }

                }

                result =  true;
            }
             catch (Exception ex)
            {
                Console.WriteLine(ex.Message);

                result =  false;
            }

             return result;
        }
    }
}

 

客户端测试代码如下：

Guid caId, cbId, ccId;
            
            caId = Guid.NewGuid();
            CascadeA tableA =  new CascadeA
            {
                CaId = caId,
                CaContent =  " Content A1 "
            };
            
            List<CascadeB> tablesB =  new List<CascadeB>();
            List<CascadeC> tablesC =  new List<CascadeC>();
            CascadeB tableB;
            CascadeC tableC;
             for ( int i =  1; i <=  3; i++)
            {
                cbId = Guid.NewGuid();
                tableB =  new CascadeB
                {
                    CbId = cbId,
                    CaId = caId,
                    CbContent =  " Content B " + i.ToString()
                };
                tablesB.Add(tableB);

                 for ( int j =  1; j <=  3; j++)
                {
                    ccId = Guid.NewGuid();
                    tableC =  new CascadeC
                    {
                        CcId = ccId,
                        CbId = cbId,
                        CcContent =  " Content C " + i.ToString() + j.ToString()
                         // CcContent = sb.ToString()
                    };
                    tablesC.Add(tableC);
                }
            }

            CascadeTableService service =  new CascadeTableService();
             bool result = service.AddCascadeTables(tableA, tablesB, tablesC);
             if (result)
                Console.WriteLine( " Add Cascade Tables Successfully! ");
             else
                Console.WriteLine( " Failed to add cascade tables! ");