How to query Unique Nodes in XML in C# with LINQ or XPATH?

[Anokneemous]

Hello,

I have an XML file that looks like this. What I need to be able to do is query all the unique B(s) nodes so that I end up with N1/V1, N3/V3, N5/V5 etc as an all up value list that I can loop through. I am hoping that I dont have to preparse all the XML to get all the possible values and then discover the duplicates after. I know I can do this, but was hoping XPATH or Linq or something could help

<?xml version="1.0" encoding="utf-8"?>
<TopLevel>
<Ps name="p1" value="v1">
<As name="a1" value="v1">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n5" value="v5"></Bs>
</As>
<As name="a2" value="v2">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n4" value="v4"></Bs>
</As>
<As name="a3" value="v3">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n4" value="v4"></Bs>
<Bs name="n6" value="v6"></Bs>
</As>
</Ps>
<Ps name="p2" value="v2">
<As name="a1" value="v1">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n5" value="v5"></Bs>
</As>
<As name="a2" value="v2">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n4" value="v4"></Bs>
</As>
<As name="a3" value="v3">
<Bs name="n1" value="v1"></Bs>
<Bs name="n3" value="v3"></Bs>
<Bs name="n4" value="v4"></Bs>
<Bs name="n6" value="v6"></Bs>
</As>
</Ps>
</TopLevel>


Thanks!

Continue reading...