C# -Fetch Node Value and corresponding count for XML elements

Question

I have an XML in below format. This XML is assigned to an XDocument object.

<root>
<event>
<command>A1</command>
</event>
<event>
<command>B1</command>
</event>
<event>
<command>A1</command>
</event>
<event>
<command>C1</command>
</event>
</root>

I need to fetch the Node Value for all <command> nodes and the number of times each of them occur. In the above case, my desired output would be

A1 2
B1 1
C1 1

I also need the above results to go into object as below

var cmdList=from appinfo in doc.Root.Elements()
                    select new
                    {
                     Cname= ...
                     CCount =...
                     }

Have you tried anything?

bit
– bit

2015-04-08 10:53:56 +00:00
Commented Apr 8, 2015 at 10:53 — bit
– bit, Commented Apr 8, 2015 at 10:53

Rahul Singh · Accepted Answer · 2015-04-08 11:14:06Z

3

Use GroupBy:-

var result = xdoc.Descendants("event")
                 .Where(x => !String.IsNullOrEmpty((string)x.Element("command")))
                 .GroupBy(x => (string)x.Element("command"))
                 .Select(x => new
                             {
                                Value = x.Key,
                                Count = x.Count()
                             });

edited Apr 8, 2015 at 11:14

answered Apr 8, 2015 at 10:55

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

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

2 Comments

mhn Over a year ago

Yes, this is just what I wanted! only slight improvement. How can i get rid of nulls. One of the x.Key value is null. Where should my where clause go

Rahul Singh Over a year ago

@mhn - Just filter it before grouping, check my update.

Collectives™ on Stack Overflow

C# -Fetch Node Value and corresponding count for XML elements

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related