get attribute value from multiple elements with same name and attribute value of one other element in xml

Question

I have got a xml file which looks like this:

<events>
    <event id="12345">
        <option href="1"></option>
        <option href="2"></option>
        <option href="3"></option>
        <option href="4"></option>
    </event>
</events>

I am trying to select a pair of information from these nodes: the event id (12345) and the attribute of the elements option

var nodeWithOptions = from n in xml.Descendants("event")
                      select new
                      {
                           id = n.Attribute("id").Value,
                           options = n.Elements("option").Attributes("href").ToString(),
                      };

unfortunately this produces the following for options inside my foreach-loop: item.options = "System.Xml.Linq.Extensions+d__8"

What I want is: 12345, 1234 (yes I do not mind if the attribute value of the 4 option elements are in one string. And I also cannot change the xml file and I would prefer to use only linq.

MarcinJuraszek · Accepted Answer · 2015-03-15 01:09:08Z

2

var nodeWithOptions = from n in xml.Descendants("event")
                      select new
                      {
                           id = (string)n.Attribute("id"),
                           options = n.Elements("option")
                                      .Select(x => (string)x.Attribute("href"))
                                      .ToList(),
                      };

This will you List<string> with values of href attribute on option elements under given event element.

answered Mar 15, 2015 at 1:09

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

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

Collectives™ on Stack Overflow

get attribute value from multiple elements with same name and attribute value of one other element in xml

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related