title: How to group rows using LINQ to Entity separating values with commas?
body: <p>Below is my LINQ Query, that im using to select <code>ITEMS</code>:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      whatsmydiscountEntities ctx = new whatsmydiscountEntities();
  
      int IdRelationshipItems = Convert.ToInt32(Request.QueryString["IdRelationshipItems"]);
      int IdProductService = Convert.ToInt32(Request.QueryString["IdProductService"]);
  
      var Items = (from es in ctx.State
                  join ie in ctx.ItemsStates on es.StateId equals ie.StateId 
                  join i in ctx.Items on ie.IdItem equals i.IdItem 
                  join iir in ctx.ItemsRelationshipItems on i.IdItem equals iir.IdItem
                  join ir in ctx.RelationshipItems on iir.IdRelationshipItems equals ir.IdRelationshipItems 
                  join ips in ctx.ItemsProductsServices on i.IdItem equals ips.IdItem 
                  join ps in ctx.ProductsServices on ips.IdProductService equals ps.IdProductService
                   where iir.IdRelationshipItems == IdRelationshipItems
                  &amp;&amp; ips.IdProductService == IdProductService
                  &amp;&amp; ir.Active == 1 
                  &amp;&amp; i.Active == 1
                  select new
                             {
                                 ItemName = i.Name,
                                 StateSigla = es.Sigla, 
                                 ProductServiceName = ps.Ttitle, 
                                 RelationshipItemName = ir.Name, 
                                 RelationshipItemImage = ir.Image, 
                                 RelationshipItemActive = ir.Active, 
                                 ItemSite = i.Site,
                                 ItemDescription = i.Description,
                                 ItemAddress = i.Address,
                                 Iteminformationdiscount = i.information_discount,
                                 ItemLogo = i.Logo,
                                 ItemActive = i.Active,
                                 StateId = ie.StateId, 
                                 IdRelationshipItems = iir.IdRelationshipItems,
                                 IdProductService = ips.IdProductService
                              }).ToList();
  }
  </code></pre>
  
  <p>As you can see, the result will be 1 row for each state, if the user passes the <code>IdRelationshipItems</code> and the <code>IdProductService</code>.</p>
  
  <p>Instead of 1 row for each state with the same information, I'd like to show only 1 row and all the states separated by commas. What do I need to change to do this?</p>