Reading child nodes from xml string using C#, LINQ

Question

- <entry xml:base="http://testserver.windows.net/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:etag="W/"datetime'2015-08-30T00%3A04%3A02.9193525Z'"">
  <id>http://testserver.windows.net/Players(PartitionKey='zzz',RowKey='000125')</id> 
  <category term="testServer.Players" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> 
  <link rel="edit" title="Players" href="Players(PartitionKey='zzz',RowKey='000125')" /> 
  <title /> 
  <updated>2014-04-30T00:53:42Z</updated> 
- <author>
  <name /> 
  </author>
- <content type="application/xml">
- <m:properties>
  <d:PartitionKey>zzz</d:PartitionKey> 
  <d:RowKey>000125</d:RowKey> 
  <d:Timestamp m:type="Edm.DateTime">2014-04-30T00:04:02.9193525Z</d:Timestamp> 
  <d:Name>Black color</d:Name> 
  <d:Comments>Test comments</d:Comments> 
  </m:properties>
  </content>
  </entry>

How can I read "m:properties" descendants using C# or LINQ. This xml string is stored in variable of type XElement

har07 · Accepted Answer · 2015-08-30 02:29:36Z

2

You can use combination of XNamespace+"element local name" to reference element in namespace, for example :

XElement myxelement = XElement.Parse("your XML string here");
XNamespace m = "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata";
List<XElement> properties = myxelement.Descendants(m+"properties").ToList();

answered Aug 30, 2015 at 2:29

har07

89.5k12 gold badges87 silver badges143 bronze badges

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

1 Comment

Ali Over a year ago

One more question in case of collection. I have just posted new question stackoverflow.com/questions/32292975/…

Community · Accepted Answer · 2017-05-23 11:50:39Z

0

I think this could show you how to use Linq to XML

read the data from XML Structure using c#

If anything else makes problems, just debug a little, see what you get from L2X operation, and move a step deeper trough data tree.

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Aug 30, 2015 at 1:20

Darko

875 bronze badges

Comments

Cistoran · Accepted Answer · 2015-08-30 01:22:22Z

0

Using Linq2XML

var xDoc = XDocument.Load(filename);
var dict = xDoc.Descendants("m:properties")
           .First()
           .Attributes()
           .ToDictionary(x => x.Name, x => x.Value);

answered Aug 30, 2015 at 1:22

Cistoran

1,59715 gold badges37 silver badges55 bronze badges

Comments

flyfrog · Accepted Answer · 2015-08-30 02:03:10Z

Setup namespace manager. Note that .net library does not support default namespace, so I added prefix "ns" to default namespace.

use xpath or linq to query xml. Following example uses xpath.

            XmlNamespaceManager NamespaceManager = new XmlNamespaceManager(new NameTable());
        NamespaceManager.AddNamespace("base", "http://testserver.windows.net/");
        NamespaceManager.AddNamespace("d", "http://schemas.microsoft.com/ado/2007/08/dataservices");
        NamespaceManager.AddNamespace("m", "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata");
        NamespaceManager.AddNamespace("ns", "http://www.w3.org/2005/Atom"); XDocument doc = XDocument.Parse(XElement);

    var properties = doc.XPathSelectElement("/ns:entry/ns:content/m:properties", NamespaceManager);

Collectives™ on Stack Overflow

Reading child nodes from xml string using C#, LINQ

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related