title: group by in LINQ query
body: <p>I've got a DataTable where i want to perform a GroupBy query on.</p>
  
  <pre><code>year    url      type     id
  =============================
          someurl  image    0
  2003             date     0
          someurl  image    1
  2009             date     1
  </code></pre>
  
  <p>I've managed to group on my id, but I am not able to select the columns "year" and "Url".</p>
  
  <p>This is my query:</p>
  
  <pre><code>var query = from row in table.AsEnumerable()
              let uri = row["uri"]
              group row by row.Field&lt;int&gt;("id") into grp
              orderby grp.Key
              select new
              {
                  ID = grp.Key,
              };
  </code></pre>
  
  <p>How can i select the columns year and url?</p>
  
  <p>Thanks in advance.</p>