title: Select a field that is not in Group By clause in LINQ
body: <p>could anybody help me about 
  "How to select a field that is not in Group By clause in LINQ"</p>
  
  <pre><code>  var ReportData = 
        from a in context.Table1
        from b in context.Table2
        where a.personelID == b.ID
        &amp;&amp; a.DateField.Value.Year == 2011
        group a by new { a.personelID, b.Name, b.Surname} into grouping
        select new
        {
             // grouping.Key.DateField,
            Name= grouping.Key.Name,
            Surname= grouping.Key.Surname,
            PagaBruto =  grouping.Sum(i =&gt; i.Bruto)),
        };
  </code></pre>
  
  <p>I can't select the field <code>"DateField"</code> that is in <strong>Table1</strong>, I don't want to have this field in <code>Group By</code>, because I will get a wrong result.
  THANKS!</p>