title: Linq or Lambda Expression for returning comma separated values
body: <p>How can I get a list of comma separated values, like so:</p>
  
  <pre><code>CategoryName-ProductName1,ProductName2,etc
  </code></pre>
  
  <p>This code returns Product names that are comma-separated, but at the begening of the series I want the category name to appear and the preceding product names:</p>
  
  <pre><code>var result = from Cats in Categories
      where Cats.Id == 39
      select new { 
          Products = Cats.Products, 
          Cats = Cats
      }.
      Products.
      Select(Products =&gt; Products.Name).
      Aggregate((Items, Item) =&gt; Items + "," + Item);
  </code></pre>