title: How to use group by and multiple select string join
body: <pre><code>DataTable dt = new DataTable();
         using (SqlDataAdapter da = new SqlDataAdapter(comcom))
           {
             da.Fill(dt);
           }
  var zxc = from uu in dt.AsEnumerable()
    select new dino1
     {
        UserName = uu.Field&lt;string&gt;(&quot;UserName&quot;),
        Role = uu.Field&lt;string&gt;(&quot;Role&quot;),
        appcode = uu.Field&lt;string&gt;(&quot;appcde&quot;),
        fullname = uu.Field&lt;string&gt;(&quot;fullname&quot;),
        scheduledate = uu.Field&lt;DateTime&gt;(&quot;Scheddte&quot;),
        datecreated = uu.Field&lt;DateTime&gt;(&quot;DateCreated&quot;),
        doctypes = uu.Field&lt;string&gt;(&quot;doctype&quot;),
        trans = uu.Field&lt;string&gt;(&quot;transactions&quot;),
        qqqq = uu.Field&lt;string&gt;(&quot;quantity&quot;),
  
    };
  var res1 = zxc.GroupBy(cc =&gt; cc.appcode).Select(dd =&gt; new dino1 { appcode = dd.Key, doctypes = 
             string.Join(&quot;, &quot;, dd.Select(ee =&gt; ee.doctypes).ToList()), trans = string.Join(&quot;, &quot;, 
             dd.Select(ee =&gt; ee.trans).ToList()), qqqq = string.Join(&quot;, &quot;, dd.Select(ee =&gt; 
             ee.qqqq).ToList()) });
  
  var namaewa = res1.ToList();
  </code></pre>
  <p>The problem is I want to add another key for GroupBy aside from appcode and another selection for it to be included at the list and displayed at my view. Is it impossible to add another key or Selection while using Model? because if i didn't use Model, it becomes anonymous type and i can add another key or selection, but the View don't accept anonymous type so i have to do it in model.</p>