C# - Select XML Descendants with Linq

Question

I have the following XML structure:

<row>
  <field name="Id">1</field>
  <field name="AreaId">1</field>
  <field name="Name">ת&quot;א</field>
</row>
<row>
  <field name="Id">2</field>
  <field name="AreaId">4</field>
  <field name="Name">אבטליון</field>
</row>

I want to iterate over the name nodes with Linq. I tried this:

var items = (from i in doc.Descendants("row")
                     select new
                     {
                         Text = i.Value

                     }).ToList();

But it didn't work the way I need it to. Any suggestions?

score 19 · Accepted Answer · answered Sep 17 '09 at 14:52

19

var items = doc.Descendants("field")
               .Where(node => (string)node.Attribute("name") == "Name")
               .Select(node => node.Value.ToString())
               .ToList();

answered Sep 17 '09 at 14:52

Mehrdad Afshari

414,610
91
852
789

1

What doc.Descendants does in linq? – KendoStarter Nov 18 '18 at 20:16

score 11 · Answer 2 · answered Sep 17 '09 at 14:52

First of all, make sure your XML has a single root node:

<rows>
<row>
  <field name="Id">1</field>
  <field name="AreaId">1</field>
  <field name="Name">ת&quot;א</field>
</row>
<row>
  <field name="Id">2</field>
  <field name="AreaId">4</field>
  <field name="Name">אבטליון</field>
</row>
</rows>

After that you can use the following code to load the xml:

string xml = //Get your XML here    
XElement xElement = XElement.Parse(xml);
//This now holds the set of all elements named field
var items = 
       xElement
      .Descendants("field")
      .Where(n => (string)n.Attribute("name") == "Name");

ray, you are my favourite. big ups. – RhysC Nov 16 '11 at 11:19 — RhysC, Nov 16 '11 at 11:19

score 1 · Answer 3 · answered Aug 06 '10 at 19:17

1

I think Linq to Sql is the most direct approach:

var items = (from c in doc.Descendants("field")
            where c.Attribute("name").Value == "Name"
            select c.Value
            ).ToList();

answered Aug 06 '10 at 19:17

Perry Tribolet

2,624
1
21
9

7

This is "Query comprehension syntax", not Linq-to-sql :) – Lee Campbell Nov 16 '11 at 11:19

C# - Select XML Descendants with Linq

3 Answers3

Linked