title: How to use a LINQ query to get XElement values when XElements have same name
body: <p>I have a piece of xml like the following:</p>
  
  <pre><code>&lt;Table&gt;
    &lt;Record&gt;
      &lt;Field&gt;Value1_1&lt;/Field&gt;
      &lt;Field&gt;Value1_2&lt;/Field&gt;
    &lt;/Record&gt;
    &lt;Record&gt;
      &lt;Field&gt;Value2_1&lt;/Field&gt;
      &lt;Field&gt;Value2_2&lt;/Field&gt;
    &lt;/Record&gt;
  &lt;/Table&gt;
  </code></pre>
  
  <p>What i would like is a LINQ query that generates an IEnumerable that i can assign as the datasource of a DataGrid. What i have so far is as follows:</p>
  
  <pre><code>var temp = from record in table.Elements("Record")
              select record.Element("Field").Value
  </code></pre>
  
  <p>The fact that I can have multiple field elements is my stumbling block.</p>
  
  <p>In the above example, what i need is something like an <code>IEnumerable&lt;string,string&gt;</code>.
  The datagrid would look something like this:</p>
  
  <pre><code>Value1_1, Value1_2
  Value2_1, Value2_2
  </code></pre>