Linq query to access data from xml

Question

I have a XML file containing some elements like

 <root>
    <gp>
      <i>1</i>
      <i>3</i>
      <i>5</i>
    </gp>
    <gp>
      <i>5</i>
      <i>6</i>
    </gp>
     . 
     . 
 </root>

Now i want to write a query by which i will get all gp elements which contains the <i> element with value 5?`

Ienumerable<XElement> variable = document.Elements("gp").where( p => p. now here i got stuck because here we have to iterate <i> elements also — Gaurav
– Gaurav, Commented Apr 28, 2012 at 18:56

MarcinJuraszek · Accepted Answer · 2012-04-28 18:58:27Z

2

var results = from gp in doc.Descendants("gp")
              where gp.Elements("i").Any(i => (int)i == 5)
              select gp

And in method-based syntax:

var results = doc.Descendants("gp").Where(gp => gp.Elements("i").Any(i => (int)i == 5));

answered Apr 28, 2012 at 18:58

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

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

3 Comments

I think it would be better to use i.value == "5", I don't think you can convert XElement to int.

@ErikPhilips: Yes you can, try it out