how to parse xml like this using linq to a object

Question

I have following xml as a response to a service not i want to parse this to a key value properties object. but it is not working. response - I want object with name as Key prop and value as value prop of object.

<lst name="industry">
  <int name="Accounting">3</int> 
  <int name="Engineering">0</int> 
  <int name="Human Resources and Adminstration">0</int> 
  <int name="Software/IT">0</int>

<lst name="industry"><int name="Accounting">3</int> <int name="Engineering">0</int> <int name="Human Resources and Adminstration">0</int> <int name="Software/IT">0</int> — Anu
– Anu, Commented Apr 4, 2012 at 11:19
Possible duplicate: stackoverflow.com/questions/670563/linq-to-read-xml — Craig
– Craig, Commented Apr 4, 2012 at 11:25

DaveShaw · Accepted Answer · 2012-04-04 11:23:48Z

4

You can do it using Linq-Xml to select the int elements and Linq-Objects' ToDictionary() extension method to select the attribute as the key and the element's value as the value in your dictionary:

var xml = @"<lst name=""industry"">
  <int name=""Accounting"">3</int>
  <int name=""Engineering"">0</int>
  <int name=""Human Resources and Adminstration"">0</int>
  <int name=""Software/IT"">0</int>
  </lst>";

var dict =
    XDocument.Parse(xml)
    .Root
    .Elements("int")
    .ToDictionary(xe => xe.Attribute("name").Value, xe => int.Parse(xe.Value));

answered Apr 4, 2012 at 11:23

DaveShaw

52.9k18 gold badges118 silver badges142 bronze badges

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

Comments

Taher · Accepted Answer · 2012-04-04 11:30:20Z

1

Your XML is not properly formatted. I believe this is how your XML looks?

<lst name="industry">
 <int name="Accounting">3</int> 
 <int name="Engineering">0</int> 
 <int name="Human Resources and Adminstration">0</int> 
 <int name="Software/IT">0</int> 
</lst>

For that case, you can do..

XDocument result = XDocument.Load(new StringReader("<lst name=\"industry\">" + 
                                                           "<int name=\"Accounting\">3</int>" + 
                                                           "<int name=\"Engineering\">0</int>" +
                                                           "<int name=\"Human Resources and Adminstration\">0</int>" +
                                                           "<int name=\"Software/IT\">0</int>" + 
                                                           "</lst>"));            


        var tmpTable = (from i in result.Descendants("int")
                        select new
                        {
                            Key = i.Attribute("name"),
                            Value = i.Value
                        }).ToDictionary(t => t.Key, t => t.Value);

answered Apr 4, 2012 at 11:30

Taher

7621 gold badge9 silver badges27 bronze badges

1 Comment

DaveShaw Over a year ago

You know there is a XDocument.Parse(string xml) method saves you having to create a StringReader().

Collectives™ on Stack Overflow

how to parse xml like this using linq to a object

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related