Prasad Kanaparthi Prasad Kanaparthi - 2 months ago 14
C# Question

Exception: The XPath expression evaluated to unexpected type System.Xml.Linq.XAttribute

I've an XML file like below:

<Employees>
<Employee Id="ANZ001">
<Name>Prasad 1</Name>
<Mobile>9986730630</Mobile>
<Address Type="Perminant">
<City>City1</City>
<Country>India</Country>
</Address>
<Address Type="Temporary">
<City>City2</City>
<Country>India</Country>
</Address>
</Employee>


Now I want get all Address Type's.

I tried like below using XPath and I'm getting exception.

var xPathString = @"//Employee/Address/@Type";
doc.XPathSelectElements(xPathString); // doc is XDocument.Load("xml file Path")



Exception: The XPath expression evaluated to unexpected type
System.Xml.Linq.XAttribute.


Is there any issue with my XPath?

Answer

Your XPath is fine (although you might want it to be more selective), but you have to adjust how you evaluate it...

XPathSelectElement(), as its name implies, should only be used to select elements.

XPathEvaluate() is more general and can be used for attributes. You can enumerate over the results, or grab the first:

var type = ((IEnumerable<object>)doc.XPathEvaluate("//Employee/Address/@Type"))
                                    .OfType<XAttribute>()
                                    .Single()
                                    .Value;