CODEWITHSUNDEEP
c#xmllinqlinq-to-xml
Ramzy Abourafeh
Ramzy Abourafeh

Reputation: 1195

How to convert XML to Dictionary

I've xml as following:

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <data name="LogIn">Log In</data>
  <data name="Password">Password</data>
</root>

I success to do that without Linq, any one can help me to convert the following code to Linq:

using (XmlReader reader = XmlReader.Create(_xml))
{
    while (reader.Read())
    {
       if (reader.NodeType == XmlNodeType.Element && reader.LocalName == "data")
       {
          reader.MoveToAttribute("name");
          string key = reader.Value;
          reader.MoveToContent();
          string value = reader.ReadElementContentAsString();
          _dictionary.Add(key, value);
       }
    }
    reader.Close();
}

Upvotes: 18

Views: 14307

Answers (3)

Felix Too
Felix Too

Reputation: 11931

This is an old question, but in case someone comes across a 'Typed' xml (e.g from a SharedPreference file of an android app), you can handle it as below: Here is a sample of such an xml I took from an Instagram app.

<?xml version='1.0' encoding='utf-8' standalone='yes' ?>
<map>
<boolean name="pinnable_stickers" value="false" />
<string name="phone_number">+254711339900</string>
<int name="score" value="0" />
<string name="subscription_list">[]</string>
<long name="last_address_book_updated_timestamp" value="1499326818875" />
 //...other properties
</map>

Note the inconsistency in the value property. Some fields(e.g of type string) don't have it explicitly defined. 

var elements = XElement.Load(filePath)
.Elements()
.ToList();
var dict = new Dictionary<string, string>();    
var _dict = elements.ToDictionary(key => key.Attribute("name").Value,
                        val => val.Attribute("value") != null ?
                        val.Attribute("value").Value : val.Value);

Upvotes: 0

Bilal Hashmi
Bilal Hashmi

Reputation: 1485

XDocument xdoc = XDocument.Load("test.XML");
var query = xdoc.Descendants("root")
                .Elements()
                .ToDictionary(r => r.Attribute("name").Value,
                             r => r.Value);

Remeber to include :

using System.Linq;
using System.Xml.Linq;

Upvotes: 0

Sergey Berezovskiy
Sergey Berezovskiy

Reputation: 236228

var xdoc = XDocument.Load(path_to_xml);
_dictionary = xdoc.Descendants("data")
                  .ToDictionary(d => (string)d.Attribute("name"),
                                d => (string)d);

Upvotes: 21

Related Questions