How to use Ancestors with Descendants in LINQ to XML?

How do I get the contents of a node whose immediate ancestor is <sec> using linq 2 xml. Here is a sample xml file</div> <div id="pastingspan1"> <div class="dp-highlighter"> <div class="bar"></div> <ol start="1" class="dp-xml"> <li class="alt"><?xml version="1.0" encoding="UTF-8"?> </li> <li class=""><article article-type="proceedings" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:oasis="http://www.niso.org/standards/z39-96/ns/oasis-exchange/table"> </li> <li class="alt"><front> </li> <li class=""><title-group> </li> <li class="alt"><title>SMALL angle scattering polarization biopsy: a comparative analysis of various skin diseases</title> </li> <li class=""></title-group> </li> <li class="alt">.... </li> <li class="">.... </li> <li class="alt"></front> </li> <li class=""><body> </li> <li class="alt"><boxed-text id="s1" position="anchor"> </li> <li class=""><sidebar-label>S1.</sidebar-label> </li> <li class="alt"><sec id="sec1"> </li> <li class=""><title>EXPERIMENTAL TECHNIQUE</title> </li> <li class="alt"><p>In the case of lupus the changes in the basal membrane adversely affect differentiation of the epidermis; this results in disorders of keratinization combined with progressive atrophy.</p> </li> <li class=""></sec> </li> <li class="alt"></boxed-text> </li> <li class="">.... </li> <li class="alt">.... </li> <li class=""></body> </li> </ol> </div> </div> <div>I'm trying to get the value EXPERIMENTAL TECHNIQUE from the above example using both Descendants and Ancestors method of LINQ 2 XML. I've tried</div> <div id="pastingspan1"> <div class="dp-highlighter"> <div class="bar"></div> <ol start="1" class="dp-c"> <li class="alt">var item=from x in doc.Descendants("label") </li> <li class="">where x.Ancestors("sec") </li> <li class="alt">select x; </li> </ol> </div> </div> <div>but getting an error</div> <div> </div> <div id="pastingspan1"> Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<System.Xml.Linq.XElement>' to 'bool'</div> <title> whose immediate ancestor is <sec> using linq 2 xml. Here is a sample xml file</div><div><div class="dp-highlighter"><div class="bar"></div><ol start="1" class="dp-xml"><li class="alt"><?xml version="1.0" encoding="UTF-8"?> </li><li class=""><article article-type="proceedings" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:oasis="http://www.niso.org/standards/z39-96/ns/oasis-exchange/table"> </li><li class="alt"><front> </li><li class=""><title-group> </li><li class="alt"><title>SMALL angle scattering polarization biopsy: a comparative analysis of various skin diseases</title> </li><li class=""></title-group> </li><li class="alt">.... </li><li class="">.... </li><li class="alt"></front> </li><li class=""><body> </li><li class="alt"><boxed-text id="s1" position="anchor"></li><li class="alt"><sidebar-label>S1.</sidebar-label></li><li class="alt"><sec id="sec1"> </li><li class=""><title>EXPERIMENTAL TECHNIQUE</title> </li><li class="alt"><p>In the case of lupus the changes in the basal membrane adversely affect differentiation of the epidermis; this results in disorders of keratinization combined with progressive atrophy.</p> </li><li class=""></sec></li><li class=""></boxed-text> </li><li class="alt">.... </li><li class="">.... </li><li class="alt"></body> </li></ol></div>I'm trying to get the value EXPERIMENTAL TECHNIQUE from the above example using both Descendants and Ancestors method of LINQ 2 XML. I've tried</div><div><div class="dp-highlighter"><div class="bar"></div><ol start="1" class="dp-c"><li class="alt">var item=from x in doc.Descendants("label") </li><li class=""> where x.Ancestors("sec") </li><li class="alt"> select x; </li></ol></div>but getting an error</div><div> Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<System.Xml.Linq.XElement>' to 'bool'</div>

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
where x.Ancestors("sec").Any();
+1
ValoChele9y ago
@Nilesh Shah,
I want to check whether the node title has a immediate ancestor node sec, if so then get the content of the node title.
0
Nilesh Shah9y ago
but what is your condition?

what you want to check in where condition?

where x.Ancestors("sec")

you have to write some condition in where statement

e.g.

where x.Ancestors("sec") == "sec1"

or something like that.
0