XML to list using LINQ

Question

have an XML file like this:

<VS>
  <Fields>
    <Field Id="$1*">Column1</Field>
    <Field Id="$2*">Column2</Field>
    <Field Id="$3*">Column3</Field>
  </Fields>
</VS>

When I use LINQ to XML using the following statement:

 XDocument doc = XDocument.Parse(s);
var q = doc.Descendants("Fields").ToList();

I get a single entry in list as Column1Column2Column3, whereas I want it as 3 separate entities like Column1, Column2, Column3.

Can anyone help?

Kirill Polishchuk · Accepted Answer · 2012-07-26 05:36:08Z

4

Use Field instead of Fields:

var q = doc.Descendants("Field").ToList();

answered Jul 26, 2012 at 5:36

Kirill Polishchuk

56.4k11 gold badges125 silver badges127 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:28:04Z

0

you should use XElement.Parse(BuildNode.InnerXml) instead of just passing the raw property in.

CommunityBot

11 silver badge

answered Jul 26, 2012 at 5:12

Viral Shah

2,2465 gold badges22 silver badges36 bronze badges

sanar · Accepted Answer · 2012-07-26 05:45:30Z

0

Just used the following code which returned list of strings.

var q = doc.Descendants("Field").Select(x => x.Value);

Thanks for all your suggestions!

answered Jul 26, 2012 at 5:45

sanar

4479 silver badges23 bronze badges