title: C# - Select XML Descendants with Linq
body: <p>I have the following XML structure:</p>
  
  <pre><code>&lt;row&gt;
    &lt;field name="Id"&gt;1&lt;/field&gt;
    &lt;field name="AreaId"&gt;1&lt;/field&gt;
    &lt;field name="Name"&gt;ת&amp;quot;א&lt;/field&gt;
  &lt;/row&gt;
  &lt;row&gt;
    &lt;field name="Id"&gt;2&lt;/field&gt;
    &lt;field name="AreaId"&gt;4&lt;/field&gt;
    &lt;field name="Name"&gt;אבטליון&lt;/field&gt;
  &lt;/row&gt;
  </code></pre>
  
  <p>I want to iterate over the <code>name</code> nodes with Linq.
  I tried this:</p>
  
  <pre><code>var items = (from i in doc.Descendants("row")
                       select new
                       {
                           Text = i.Value
  
                       }).ToList();
  </code></pre>
  
  <p>But it didn't work the way I need it to. Any suggestions?</p>