How to sort numbers in C# XML?

Question

I have the following xml code:

    <highscore>
  <score>
    <naam>Pipo</naam>
    <punten>200</punten>
  </score>
  <score>
    <naam>Harry</naam>
    <punten>400</punten>
  </score>
</highscore>

How can I sort by "punten"? So the highest number is on top?

Thanks!!

Answer 1

var xml=@" <highscore>
  <score>
    <naam>Pipo</naam>
    <punten>200</punten>
  </score>
  <score>
    <naam>Harry</naam>
    <punten>400</punten>
  </score>
</highscore>";

var doc = XDocument.Parse(xml);
var orderedScoreElements = 
      doc.Root
         .Elements("score")
         .OrderByDescending(e => (int)e.Element("punten"))
         .ToList();

and to rewrite the doc in order:

doc.Root.RemoveNodes();
doc.Root.Add(orderedScoreElements);