title: linq to xml: how to select the value from elements
body: <p>I need return a list of the element <code>&lt;AssetText&gt;</code>. My query below only returns back the first <code>AssetText</code>. Any thoughts much appreciated. </p>
  
  <pre><code>var q = from c in xDoc.Descendants("Product")
          where (int) c.Element("ProductView").Element("ViewId") == 44
          select (string) c.Element("ProductView").Element("AssetText").Element("Text");
  </code></pre>
  
  <p>&nbsp;</p>
  
  <pre><code>&lt;Product&gt;
    &lt;ProductView&gt;
      &lt;ViewId&gt;44&lt;/ViewId&gt;
      &lt;AssetText&gt;
        &lt;Text&gt;my first Asset Text&lt;/Text&gt;
      &lt;/AssetText&gt;
      &lt;AssetText&gt;
        &lt;Text&gt;my second Asset Text&lt;/Text&gt;
      &lt;/AssetText&gt;
    &lt;/ProductView&gt;
    &lt;ProductView&gt;
      &lt;ViewId&gt;45&lt;/ViewId&gt;
      &lt;AssetText&gt;
        &lt;Text&gt;my third Asset Text&lt;/Text&gt;
      &lt;/AssetText&gt;
    &lt;/ProductView&gt;
  &lt;/Product&gt;
  </code></pre>