count nodes with attribute value

Question

I am trying to switch from XmlDocument to Linq, and am struggling to get what I want.

I have XML similar to this,

<root>
<Surfer Status='5'>
    <Name>Billy</Name>
    <County>Cornwall</County>
</Surfer>
<Surfer Status='5'>
    <Name>Tim</Name>
    <County>Cornwall</County>
</Surfer>
<Surfer Status='10'>
    <Name>Ryan</Name>
    <County>Devon</County>
</Surfer>
</root>

I can count all the surfers like this.

XDocument X = XDocument.Load("Surfers.xml");
int Total = X.Descendants("Surfer").Count();

I was hoping to count all the Surfers with a Status of 5 like this

int fives = X.Descendants["Surfer[@Status='5']").Count();

but it doesn't work!

What do you mean by it doesn't work ? Are you getting an error message ? Or are you simply not getting the expected result ? — Luc Morin
– Luc Morin, Commented Nov 22, 2015 at 22:40

Hamid Pourjam · Accepted Answer · 2015-11-22 22:34:12Z

1

You can use Count overload which takes a predicate

int fives = X.Descendants("Surfer").Count(x => x.Attribute("Status")?.Value == "5");

x.Attribute("Status") will retrieve the Status attribute from the Surfer element and ?. operator prevents NullReferenceException if any of Surfer elements does not have Status attribute.

edited Nov 22, 2015 at 22:34

answered Nov 22, 2015 at 22:28

Hamid Pourjam

20.8k9 gold badges61 silver badges75 bronze badges

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

Comments

Hamid Pourjam · Accepted Answer · 2015-11-22 22:42:40Z

1

Use Where:

int fives = X.Descendants("Surfer").Where(s => (int)s.Attribute("Status") == 5).Count();

or if you really want to use XPath expression you can do it after adding using System.Xml.XPath and using XPathSelectElements:

int fives = X.XPathSelectElements("Surfer[@Status='5']").Count();

edited Nov 22, 2015 at 22:42

Hamid Pourjam

20.8k9 gold badges61 silver badges75 bronze badges

answered Nov 22, 2015 at 22:26

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

Collectives™ on Stack Overflow

count nodes with attribute value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related