How to get multiple elements by name in XML using LINQ

Question

I've the below XML:

<?xml version="1.0" standalone="yes"?>
<TestSuite>
  <TestCase Name="XXX" ID="123;234; 345; 456">
    <CodeBlock />
  </TestCase>
  <TestCase Name="East" ID="11,22,33, 44, 55">
    <CodeBlock />
  </TestCase>
</TestSuite>

I need to get all the ID and order them by ID ASC, below is my Linq:

var r = (from lv1 in xdoc.Descendants("TestCase")
         select new { ID = lv1.Attribute("ID").Value })
        .Where(d => d.ID != string.Empty)
        .GroupBy(l => l.ID)
        .ToList();

I now get:

123;234; 345; 456
11,22,33, 44, 55

But how can I get the IDs like:

It is very accurate that you have included the xml of yours. — Tolga Evcimen
– Tolga Evcimen, Commented Apr 22, 2014 at 6:13

Jon Skeet · Accepted Answer · 2014-04-22 10:44:04Z

3

It's not clear why you're grouping at all... and you just need to split the values and flatten that with SelectMany, by the looks of it:

var separators = new[] { ';', ',' };
var r = xdoc.Descendants("TestCase")
            .Select(x => (string) x.Attribute("ID"))
            .Where(ids => ids != null)
            .SelectMany(ids => ids.Split(separators,
                                         StringSplitOptions.RemoveEmptyEntries))
            .Select(id => int.Parse(id.Trim()))
            .OrderBy(id => id)
            .ToList();

Note that I've parsed each ID as integer, on the grounds that if you treat them just as strings, then "123" comes before "55". If they're actually not necessarily integers, but you want to sort any values which can be parsed as integers that way, then the ordering part becomes trickier.

edited Apr 22, 2014 at 10:44

answered Apr 22, 2014 at 6:10

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tolga Evcimen · Accepted Answer · 2014-04-22 06:00:59Z

2

This might work:

var r = (from lv1 in xdoc.Descendants("TestCase")
        select new { ID = lv1.Attribute("ID").Value }).
        Where(d => d.ID != string.Empty).OrderBy(l => int.Parse(l.ID)).ToList();

answered Apr 22, 2014 at 6:00

Tolga Evcimen

7,39011 gold badges63 silver badges97 bronze badges

4 Comments

Jerry Over a year ago

Input string was not in a correct format, "123;234; 345; 456"

Mukus Over a year ago

that's the right idea.. now just change the last OrderBy(l => int.Prase(l.ID.ToString().Replace(";", ""))) ... +1

Jerry Over a year ago

I'm puzzled, l.ID.ToString().Replace(";", "") returns string,how can it be parsed to int?

Mukus Over a year ago

Yes it will return string without the semi colon. That can be parsed into integer

Collectives™ on Stack Overflow

How to get multiple elements by name in XML using LINQ

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related