请问如何应用linq读取xml

Question

 <School>
<Text1>
  <A Value="1"/>
  <B Value="2"/>
  <C Value="1"/>
  <D Value="16"/>
  <E Value="P1,P2,P3"/>
</Text1>
<Text2>
  <A Value="2"/>
  <B Value="2"/>
  <C Value="1"/>
  <D Value="25"/>
  <E Value="P7,P8,P9"/>
</Text2>

</School>

请问怎样才能显示：Text1:1,2,1,16，P1，P2，P3；Text2:2,2,1,25，P7，P8，P9…

Answer 1

    XDocument addList = XDocument.Load(@"c:\R.xml");
    var text = addList.Descendants("School").SelectMany(x=>x.Elements());

    foreach(var node in text)
    {
      Console.WriteLine( node.Name + "," +  string.Join("," , node.Elements().Select(el=>el.Attribute("Value").Value).ToArray())); 
    }