title: Load values via junctions table
body: <p>I need to load all the rows from the <code>ItemToGroup</code> table into one field separated with a comma, I can't use <code>String.Join</code> since I'm using server mode from DevExpress, it loads the data dynamically from the database on demand. And <code>String.Join</code> only works on generic lists.</p>
  
  <p>I tried this LINQ Statement:</p>
  
  <pre><code>e.QueryableSource = From c In sqlData.ItemStores
  Select c.Price, c.Status,
  ItemGroupNames = c.ItemToGroups.Select(Function(g) g.ItemGroup.ItemGroupName)
  </code></pre>
  
  <p>Problem is that in the grid column it shows:</p>
  
  <pre class="lang-none prettyprint-override"><code>System.Collections.Generic.List`[system.string]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Z2Tsv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z2Tsv.jpg" alt="enter image description here"></a></p>