CODEWITHSUNDEEP
c#linq-to-xml
Dylan Parry
Dylan Parry

Reputation: 3453

Reorder XML nodes

I’ve got some XML that looks something like this:

<root>
    <item>Banana</item>
    <item>Apple</item>
    <item>Cherry</item>
</root>

It’s not the actual data I have, but it’ll serve the purpose here. What I want to do is use Linq to SQL to reorder the XML so that the child nodes are in alphabetical order, eg.

<root>
    <item>Apple</item>
    <item>Banana</item>
    <item>Cherry</item>
</root>

I want to be able to then call ToString() on the original XDocument and have it return the second set of XML as shown above. Is there a simple way of doing this? I’ve tried searching, but no such luck.

Upvotes: 2

Views: 3514

Answers (1)

user7116
user7116

Reputation: 64068

Perhaps:

var reordered = new XElement(
                    "root",
                    xdoc.Root.Elements("item")
                             .OrderBy(x => x.Value)
                             .Select(x => new XElement("item", x.Value)));

Or the slightly more flexible (albeit only supporting 1 nested level):

var reordered = new XElement(
                    xdoc.Root.Name,
                    xdoc.Root.Elements()
                             .OrderBy(x => x.Value)
                             .Select(x => new XElement(x.Name, x.Value)));

Upvotes: 2

Related Questions