use LINQ on XmlNodeList

Question

<X version="1.0">   <Y id="abc" abv="a"/>   <Y id="edf" abv="e"/> </X> 

I want to select the node whose id is "abc", and return its abv "a".

XmlDocument doc = new XmlDocument(); doc.Load(filePath); XmlNodeList list = doc.SelectNodes("X/Y"); var node = list.Cast<XmlNode>().Where(node => node["id"].InnerText == "abc")                                .Select(x=>x["abv"].InnerText); 

But it does't work, node["id"].InnerText is always "". Can you point out where is a problem?

Thanks a lot

Answer 1

Aside from the fact what your code snippet wouldn't be compiled because of non-unique node variable (first outside of linq query and second in "where" method lambda), you have also missed Attributes in your query.

It should be something like

var node = list.Cast<XmlNode>()                .Where(n => n.Attributes["id"].InnerText == "abc")                .Select(x => x.Attributes["abv"].InnerText);