光脚丫学LINQ(010)：将内存中的对象转换为XML

视频演示：http://u.115.com/file/f24db1fdfa

通过 LINQ 查询，可以轻松地在内存中的数据结构、SQL 数据库、ADO.NET 数据集和 XML 流或文档之间转换数据。下面的示例将内存中的数据结构中的对象转换为 XML 元素。

List<Student> Students = new List<Student>()
{
    new Student {
        FirstName="Svetlana",
        LastName="Omelchenko", 
        ID=111, 
        Scores = new List<int>{97, 92, 81, 60}},
    new Student {
        FirstName="Claire", 
        LastName="O’Donnell", 
        ID=112, 
        Scores = new List<int>{75, 84, 91, 39}},
    new Student {
        FirstName="Sven", 
        LastName="Mortensen", 
        ID=113, 
        Scores = new List<int>{88, 94, 65, 91}},
};

// Create the query.
var StudentsToXML = new XElement("Root",
    from student in Students
    let ScoreString = String.Format("{0},{1},{2},{3}",
        student.Scores[0],
        student.Scores[1],
        student.Scores[2],
        student.Scores[3])
    select new XElement("Student",
               new XElement("FirstName", student.FirstName),
               new XElement("LastName", student.LastName),
               new XElement("Scores", ScoreString)
            ) 
        );

// Execute the query.
Console.WriteLine(StudentsToXML);

// Keep the console open in debug mode.
Console.WriteLine("Press any key to exit.");
Console.ReadKey();

此代码生成下面的 XML 输出：

<Root>
  <Student>
    <FirstName>Svetlana</FirstName>
    <LastName>Omelchenko</LastName>
    <Scores>97,92,81,60</Scores>
  </Student>
  <Student>
    <FirstName>Claire</FirstName>
    <LastName>O’Donnell</LastName>
    <Scores>75,84,91,39</Scores>
  </Student>
  <Student>
    <FirstName>Sven</FirstName>
    <LastName>Mortensen</LastName>
    <Scores>88,94,65,91</Scores>
  </Student>
</Root>