Using LINQ to query XML file

Question

I have an XML document that looks like this. It has been created using the Diagram feature of DevExpress.

<XtraSerializer version="17.1.3.0">
   <Items>
     <Item1 ItemKind="DiagramRoot">
       <Children>
         <Item1  Shape="Triangle" Content="AA" /> 
         <Item2  Shape="Triangle" Content="AB" /> 
         <Item3  Shape="Octagon"  Content="A"  /> 
       </Children>
     </Item1>
   </Items>
 </XtraSerializer>

I would like to Query it to return the Shape and Content of all items under Children. I tried the query below but it does not work.

XDocument document = XDocument.Load("C:\\Users\\Jb\\Desktop\\Network_Base.xml");

var items = from r in document.Descendants("Children")
            select new
            {
                Content = r.Attribute("Content").Value,
                Shape = r.Attribute("Shape").Value,
            };

foreach (var r in items)
{               
    Console.WriteLine(r.Content + r.Shape);
}

Gilad Green · Accepted Answer · 2017-06-29 17:59:20Z

2

Try following :

var results = doc.Descendants("Children").FirstOrDefault().Elements()
                 .Where(x => x.Attribute("Content") != null).Select(r => new {
                     Content = r.Attribute("Content").Value,
                     Shape = r.Attribute("Shape").Value
                 }).ToList();

edited Jun 29, 2017 at 17:59

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

answered Jun 29, 2017 at 15:34

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

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

6 Comments

jbf Over a year ago

Hi. Thank you for your help. Unfortunately it didn't work. I get an error when the query is executed.

Derek Over a year ago

I tested it as well. It works. Is your xml different than what you posted?

jdweng Over a year ago

I tested it with the posted code before posting and did not get any errors. Add picture of results

jbf Over a year ago

Actually you are right, it works, i made stupid mistake, thanks a lot.

jbf Over a year ago

Hi again. If my xml file has another item like this: <Item4 Shape="Arrow" Start="AA" End="A" /> . The query you gave does not work since item4 does not have the same Attribute as the others. How can I exclude item4 from the query?

|

Collectives™ on Stack Overflow

Using LINQ to query XML file

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related