通过LINQ to XML生成 XML

通过LINQ to XML生成 XML

    XML常常用语在客户机和服务器之间交流数据，或者多层应用程序之间交流。 

    用LINQ to SQL查询数据，再用LINQ to XML吧数据转换为XML. 

    例： 

        ....... 

        AreslabDataContext aresData = new aresData();    //创建DataContext实例 

        XElement aresCustomerOrders = new XElement("customers",    //创建XML片段实例

                      from c in aresData.Customers            //利用LINQ查询数据，DataContext对象的Customers成员作为数据源

                      select new XElement("customer",        //构建select投射

                                      new XAtrribute("ID", c.CustomerID),

                                      new XAtrribute("Company", c.CompanyName), 

                                              from o in c.orders

                                              select new XElement("order",

                                                      new XAtrribute("orderID",o,OrderID),

                                                      new XAtrribute("orderTotal", o.Order_Detail.Sum(od=>od.Quantity*od.UnitPrice))

                                      ) //end order

                        )    //end customer

         );    //end customers 

        string xmlFileName = "c:/.../aresCustomerOrders.xml"; 

        aresCustomerOrders.Save(xmlFileName);