C# Linq to XML query

Question

<World>
  <Animals>
    <Tab>
      <Dogs id ="1">
        <Dog1></Dog1>
        <Dog2></Dog2>
        <Dog3></Dog3>
      </Dogs>
      <Dogs id ="2"></Dogs>
      <Dogs id ="3"></Dogs>
    </Tab>
  </Animals>
</World>

How do I get all elements under tag where id == 1?

My Linq query. (doesn't work) why?

XDocument xml= XDocument.Load(xml.xml);
var elements = from e in xml.Descendants("Animals").Descendants("Tab").Elements("Dogs")
where e.Attribute("id").toString().Equals("1")
select c;

Could you check it please?

Thanks!

sll · Accepted Answer · 2012-02-20 15:21:37Z

3

var result = xdoc.Descendants("World")
                 .Descendants("Animals")
                 .Descendants("Tab")
                 .Elements("Dogs")
                 .Where(n => n.Attribute("id").Value == "1");

Output:

<Dogs id="1">
  <Dog1></Dog1>
  <Dog2></Dog2>
  <Dog3></Dog3>
</Dogs>

answered Feb 20, 2012 at 15:21

sll

62.7k22 gold badges109 silver badges157 bronze badges

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

1 Comment

Wild Goat Over a year ago

Thank you!! Problem was in n.Attiribute("id").VALUE. ( I forgot add .value)

Phil · Accepted Answer · 2012-02-20 16:14:48Z

1

Or use XPath:

xml.XPathSelectElements("/World/Animals/Tab/Dogs[@id=1]")

or

xml.XPathSelectElements("//Dogs[@id=1]")

which would find all Dogs wherever they occurred.

edited Feb 20, 2012 at 16:14

answered Feb 20, 2012 at 15:25

Phil

43.2k9 gold badges102 silver badges102 bronze badges

1 Comment

Henk Holterman Over a year ago

Only if you want Dogs outside of "Animals" too.

Henk Holterman · Accepted Answer · 2012-02-20 18:09:12Z

1

From your sample data I think you want

//from e in xml.Descendants("Animals").Descendants("Tab").Elements("Dogs")
from e in xml.Descendants("Animals").Elements("Tab").Descendants("Dogs")

And in the same line, Descendants("Animals") could be Elements("Animals") if you want to enforce the structure.

For the rest your query looks OK.

edited Feb 20, 2012 at 18:09

answered Feb 20, 2012 at 15:13

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

Collectives™ on Stack Overflow

C# Linq to XML query

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related