Querying xml child elements with prefixed namespace using LINQ to XML

Question

So I have some XML that generally looks like this

<wd:Data xmlns:wd="urn:com.foo.bar/GetResult">
    <wd:Result>
        <wd:field1>lorem</wd:field1>
        <wd:field2>ipsum</wd:field2>
        <wd:field3>dolor</wd:field3>
        <wd:field4>sit</wd:field4>
    </wd:Result>
</wd:Data>

The namespace is prefixed with "wd"

I'd like to be able to take each of the elements within <wd:Result>...</wd:Result> and create a new KeyValuePair<string, string> where the key is the element name and the value is the value of the element like so:

{"field1", "lorem"} {"field2", "ipsum"} {"field3", "dolor"} {"field4", "sit"}

My struggle is with the namespace prefix. I am very much a novice with LINQ but I have always been able to get something like this to work with code like this:

var data = XElement.Parse(theXml); 
XNamespace ns = "urn:com.foo.bar/GetResults"; 
var result = data.Elements(ns + "Result")
                 .Select(x => new KeyValuePair<string, string>(x.Name.LocalName, x.Value))
                 .ToList();

How should I query this data to to produce the desired result?

I'm not married to LINQ so whatever the community feels is best will be fine with me.

Do you realize that your problem had nothing to do with namespaces? — John Saunders
– John Saunders, Commented Oct 3, 2012 at 21:26

syneptody · Accepted Answer · 2012-10-03 21:14:40Z

5

It turns out that I needed to combine Descendants() with Elements()

The following code acheived exactly what I was after:

    var data = XElement.Parse(theXml);  
    XNamespace ns = "urn:com.foo.bar/GetResults";  
    var result = data.Descendants(ns + "Result")
                     .Elements()
                     .Select(x => new KeyValuePair<string, string>(x.Name.LocalName, x.Value))
                     .ToList();

edited Oct 3, 2012 at 21:14

answered Oct 3, 2012 at 20:51

syneptody

1,2801 gold badge10 silver badges27 bronze badges

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

2 Comments

Rati_Ge Over a year ago

glad to see u found solution to your problem

dotnetdev_2009 Over a year ago

This saved me a lot of time.Thanks for posting your answer

Rati_Ge · Accepted Answer · 2012-10-03 20:38:19Z

2

Ok this is not a complete solution, but I think u should get basic idea around using Namespaces inside your XML and reading data with LINQ

lest say you already loaded your XML in memory, here is how u can access that

XDocument inventory = XDocument.Load("path_to_your_file.xml");

XNamespace vs = "urn:com.foo.bar/GetResult";
var names = doc.Descendants(vs + "Result")
           .Select(x => (string) x)
           .ToList();

this is not an exact implementation for you XML structure, but I think u get the idea how to work with namespaces

answered Oct 3, 2012 at 20:38

Rati_Ge

1,2702 gold badges15 silver badges41 bronze badges

1 Comment

syneptody Over a year ago

Thank you. Your code fragment got me thinking that I needed to call Elements() after I got all of the descendants of ns + "Result"

Petter Friberg · Accepted Answer · 2016-10-04 19:19:18Z

0

you could also use the localname property and do something like this

var names  = from n in xdoc.Descendants() where n.Name.LocalName == "Result" select n;

edited Oct 4, 2016 at 19:19

Petter Friberg

21.8k10 gold badges67 silver badges116 bronze badges

answered Oct 4, 2016 at 19:15

Stetson

32 bronze badges

Collectives™ on Stack Overflow

Querying xml child elements with prefixed namespace using LINQ to XML

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related