CODEWITHSUNDEEP
c#.netxmllinq-to-xml
TheBoubou
TheBoubou

Reputation: 19903

XDocument to List of object

The content of an XDocument is the XML below.

I'd like to get a List(), see at the end of this message.

<myXml>
  <myDatas code="01">
    <myVar name="myvar" value="A" />
    <myData name="A" value="A1" />
    <myData name="B" value="B1" />
  </myDatas>
  <myDatas code="02">
    <myVar name="myvar" value="B" />
    <myData name="A" value="A2" />
    <myData name="D" value="D2" />
  </myDatas>
</myXml>

public class MyData
{
    public string MainCode { get; set; }
    public string Code { get; set; }
    public string Value { get; set; }
}

I'd like a List() this content should be like this :

new MyData { MainCode = "01"; Code = "A"; Value = "A1" };
new MyData { MainCode = "01"; Code = "B"; Value = "B1" };
new MyData { MainCode = "02"; Code = "A"; Value = "A2" };
new MyData { MainCode = "02"; Code = "D"; Value = "D2" };

Upvotes: 1

Views: 9766

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1500525

Sure - so you need something like this:

var query = from datas in doc.Root.Elements("myDatas")
            let code = (string) datas.Attribute("code")
            from data in datas.Elements("myData")
            select new MyData {
                MainCode = code,
                Code = (string) data.Attribute("name"),
                Value = (string) data.Attribute("value"),
            };

var list = query.ToList();

Note the multiple from clauses to flatten the results.

Another alternative would have been to just find all the "leaf" elements and fetch the code part from the parent:

var query = from data in doc.Descendants("myData")
            select new MyData {
                MainCode = (string) data.Parent.Attribute("code"),
                Code = (string) data.Attribute("name"),
                Value = (string) data.Attribute("value"),
            };

var list = query.ToList();

EDIT: If your document uses namespaces, that's easy too:

XNamespace ns = "http://the-uri-of-the-namespace";
var query = from data in doc.Descendants(ns + "myData")
            ...

This uses the XName operator +(XNamespace, string) overloaded operator.

Upvotes: 8

Related Questions