Selecting elements from XML file using LINQ

Question

I have this XML structure:

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
  <Document>
    <name>My Work</name>
    <Placemark>
      <name>Main Building</name>
      <Polygon>
        <extrude>1</extrude>
        <altitudeMode>relativeToGround</altitudeMode>
        <outerBoundaryIs>
          <LinearRing>
            <coordinates>
            </coordinates>
          </LinearRing>
        </outerBoundaryIs>
      </Polygon>
    </Placemark>

    <Placemark>
      <name>Office 1</name>
      <Polygon>
        <extrude>1</extrude>
        <altitudeMode>relativeToGround</altitudeMode>
        <outerBoundaryIs>
          <LinearRing>
            <coordinates>
            </coordinates>
          </LinearRing>
        </outerBoundaryIs>
      </Polygon>
    </Placemark>
  </Document>
</kml>

This goes on...

I need to select the building "name" for each of them and store this inside a list. I have written this code:

using System;
using System.Linq;
using System.Xml;
using System.Xml.Linq;
using System.Collections.Generic;

namespace dsdsdsds
{
    public class Building
    {
        public string BuildingName { get; set; }
    }

    class MainClass
    {
        public static void Main(string[] args)
        {
            List<Building> buildingNames = 
                (from e in XDocument.Load("buildings.kml").Root
                                    .Elements("Document")
                 select new Building
                 {
                     BuildingName = (string)e.Element("name")
                 }).ToList();

            foreach (var e in buildingNames)
            {
                Console.WriteLine(e);
            }
        }
    }
}

However, it doesn't seem to want to output anything and I cannot find out where I am going wrong. Could anyone help me?

Thanks

Sergey Berezovskiy · Accepted Answer · 2013-01-24 12:26:53Z

6

You forgot about namespace declared in your xml:

var xdoc = XDocument.Load("buildings.kml");
XNamespace kml = "http://www.opengis.net/kml/2.2";
var buildings = xdoc.Root.Elements(kml + "Document")
                    .Select(d => new Building {
                        BuildingName = (string)d.Element(kml + "name")
                    }).ToList();

answered Jan 24, 2013 at 12:26

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

3 Comments

Phorce Over a year ago

Thanks for the reply. When I do "foreach (var b in buildings) { Console.WriteLine (b); } All I get is: dsdsdsds.Building ??

Sergey Berezovskiy Over a year ago

You should write b.BuildingName to console. Btw are you sure your building is a Document element? Maybe you need Placemark?

Phorce Over a year ago

You have actually just made my day. I cannot thank you enough :)! But thank you ha! Have a nice day/evening/night

daryal · Accepted Answer · 2013-01-24 12:36:05Z

2

XDocument xDocument = XDocument.Load("buildings.kml");
XNamespace xNameSpace = "http://www.opengis.net/kml/2.2";

var names = from o in xDocument.Descendants(xNameSpace+"name")
            select o.Value;

I think this is the easiest way; do not forget to add namespace before the queried element.

answered Jan 24, 2013 at 12:36

daryal

15k4 gold badges40 silver badges54 bronze badges

Comments

bobblez · Accepted Answer · 2013-01-24 12:26:09Z

1

From what I can see, you're attempting to loop over the "Document" -elements and select their names. Instead, you probably want to go one step further, into the Placemark -elements, ie.

XDocument.Load("buildings.kml").Element("Document").Elements("Placemark")
                    select new Building
                    {
                        BuildingName = e.Element("name").Value
                    }).ToList();

answered Jan 24, 2013 at 12:26

bobblez

1,38020 silver badges35 bronze badges

Collectives™ on Stack Overflow

Selecting elements from XML file using LINQ

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related