How to get an element that has: on its own behalf?

Question

I need to get the CountryName name from this XML: http://api.hostip.info/?ip=12.215.42.19

XML response:

<HostipLookupResultSet version="1.0.1"
  xmlns:gml="http://www.opengis.net/gml"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:noNamespaceSchemaLocation="http://www.hostip.info/api/hostip-1.0.1.xsd">

  <gml:description>This is the Hostip Lookup
  Service</gml:description>
  <gml:name>hostip</gml:name>
  <gml:boundedBy>
    <gml:Null>inapplicable</gml:Null>
  </gml:boundedBy>
  <gml:featureMember>
    <Hostip>
      <ip>12.215.42.19</ip>
      <gml:name>Sugar Grove, IL</gml:name>
      <countryName>UNITED STATES</countryName>
      <countryAbbrev>US</countryAbbrev>
      <!-- Co-ordinates are available as lng,lat -->
      <ipLocation>
        <gml:pointProperty>
          <gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">

            <gml:coordinates>-88.4588,41.7696</gml:coordinates>
          </gml:Point>
        </gml:pointProperty>
      </ipLocation>
    </Hostip>
  </gml:featureMember>
</HostipLookupResultSet>

The problem is that I cannot include :in the method Descendantsbecause it throws:

XmlException: Chracater ':', the hexadecimal value 0x3A, cannot be included in the name.

thank

Answer 1

try it

var descendants = from i in XDocument.Load(xml).Descendants("Hostip")
select i.Element("countryName");

Update

full code to download xml and find the name countryName

string xml;
using(var web = new WebClient())
{
xml = web.DownloadString("http://api.hostip.info/?ip=12.215.42.19");
}
var descendants = from i in XDocument.Parse(xml).Descendants("Hostip")
select i.Element("countryName");

Answer 2

A small example of how to apply namespaces in LINQ to XML:

XElement doc = XElement.Load("test.xml");
XNamespace ns = "http://www.opengis.net/gml";

var firstName = doc.Descendants(ns + "name").First().Value;

Answer 3

gml; , , "gml:"

UPDATE

I am not sure in what context you are applying this, but here we use an example console application:

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

namespace LinqToXmlSample
{
    class Program
    {
        static void Main(string[] args)
        {
            XElement x = XElement.Load("http://api.hostip.info/?ip=12.215.42.19");
            foreach (XElement hostip in x.Descendants("Hostip"))
            {
                string country = Convert.ToString(hostip.Element("countryName").Value);
                Console.WriteLine(country);
            }
            Console.ReadLine();
        }
    }
}

Answer 4

var gml = (XNamespace)"http://www.opengis.net/gml";
var doc = XDocument.Load(...) or XDocument.Parse(...);
var name = doc.Descendants(gml + "featureMember").Descendants("countryName").First().Value;

Or you can use brute force and remove all namespaces:

void RemoveNamespace(XDocument xdoc)
{
    foreach (XElement e in xdoc.Root.DescendantsAndSelf())
    {
        if (e.Name.Namespace != XNamespace.None)
        {
            e.Name = XNamespace.None.GetName(e.Name.LocalName);
        }

        if (e.Attributes().Any(a => a.IsNamespaceDeclaration || a.Name.Namespace != XNamespace.None))
        {
            e.ReplaceAttributes(e.Attributes().Select(a => a.IsNamespaceDeclaration ? null : a.Name.Namespace != XNamespace.None ? new XAttribute(XNamespace.None.GetName(a.Name.LocalName), a.Value) : a));
        }
    }
}