title: Linq GroupBy and Aggregate
body: <p>Given the following list:</p>
  
  <pre><code>var data = new[]
      {
          new {category = "Product", text = "aaaa"},
          new {category = "Product", text = "bbbb"},
          new {category = "Product", text = "bbbb"},
      };
  </code></pre>
  
  <p>how do I group it by category and return an object with category and a description of the different text put together ??</p>
  
  <p>ie. would like to end yp with:</p>
  
  <pre><code>{
      categroy="Product"
      description = "aaaa,bbbb,cccc"
  }
  </code></pre>
  
  <p>tried the following GroupBy and Aggregate, but something is not right</p>
  
  <pre><code>data.GroupBy(x =&gt; x.category).Select(g =&gt; new
      {
          category = g.Key,
          description = g.Aggregate((s1, s2) =&gt; s1 + "," + s2)
       });
  </code></pre>
  
  <p>TIA</p>