Retrieve node Count in xml based on condition using linq

Question

I am unable to retrieve correct count of the nodes with attribute: IsTrue = "true" of my xml.

Code that I am using is :>>>

       Array depCnfg = (from node in xml.Descendants(Qualities).Descendants()
                           where node.Parent.Name == Qualities &&
                           (node.Attribute(ISTRUE).Value.ToString().ToLower() == "true") 
                           select { 
                           totalCount = node.Nodes().Count()}).ToArray();

XML USED: >>>

<Qualities>
 <General>
   <Tag1 IsTrue = "true">
      <SubTag1>0</SubTag1>
   </Tag1>    
   <Tag2 IsTrue = "false">
      <SubTag2>0</SubTag2>
   </Tag2>  
 </General>
</Qualities>

Here I always get the count as 2 but actually it should be 1. If anyone have an idea please share...Thanks

@Rich: the totalCount inside 'select' is having a value of 2; ie, in the xml file both <Tag1> and <Tag2> are read, which is improper. I tried using lambda expression inside Count() but its not working. — spins3
– spins3, Commented Mar 13, 2012 at 18:55
You still count all nodes with node.Nodes() , not the nodes where IsTrue == "true". — Gert Arnold
– Gert Arnold, Commented Mar 14, 2012 at 12:34

Chris Knight · Accepted Answer · 2012-07-03 22:16:51Z

1

You can use the following LINQ query to get the count. This is grabbing the 'Qualities' node and putting it into it's own element. Then we are looking at each descendant, and check the following:

Does it contain attributes
Does it contain an attribute named 'IsTrue'
Does the 'IsTrue' attribute's value equal 'true'

Then it gets the count of the elements that meet that criteria. This is assuming there is only one 'Qualities' node. In that case you would have to use XElement qualities = element.Element*s*("Qualities"); .

string sampleString = "<MAINROOT>" +
                        "<Qualities>" +
                         "<General>" +
                           "<Tag1 IsTrue = \"true\">" +
                              "<SubTag1>0</SubTag1>" +
                           "</Tag1>" +
                           "<Tag2 IsTrue = \"false\">" +
                              "<SubTag2>0</SubTag2>" +
                           "</Tag2>" +
                         "</General>" +
                        "</Qualities>" +
                    "</MAINROOT>";
        XElement element = XElement.Parse(sampleString);
        XElement qualities = element.Element("Qualities");
        if (qualities != null)
        {
            int trueCount = element.Element("Qualities")
            .Descendants()
            .Where(x => x.HasAttributes && x.Attribute("IsTrue") != null && x.Attribute("IsTrue").Value == "true")
            .Count();
        }

answered Jul 3, 2012 at 22:16

Chris Knight

1,4861 gold badge17 silver badges24 bronze badges

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

1 Comment

Chris Knight Over a year ago

I am glad! If you found this helpful, would you consider choosing the answer as the accepted answer, and uptick my response? This will close the question and also give me some credit.

Collectives™ on Stack Overflow

Retrieve node Count in xml based on condition using linq

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related