title: linq group by and select multiple columns not in group by
body: <p>I'm trying to select multiple columns not in a group by using linq - c#.</p>
  
  <p>Using linq, I'm trying to group by ISNULL(fieldOne,''),ISNULL(fieldTo,'') and then select field_One, field_Two, field_Three for each group. So for each row that the group by would return, I want to see numerous rows.</p>
  
  <p>So far I have the following, but can't seem to select all the needed columns.</p>
  
  <pre><code>var xy = tableQueryable.Where(
              !string.IsNullOrEmpty(cust.field_One)
              || ! string.IsNullOrEmpty(ust.field_Two)
              ).GroupBy(cust=&gt; new { field_One= cust.field_One ?? string.Empty, field_Tow = cust.field_Two  ?? string.Empty}).Where(g=&gt;g.Count()&gt;1).AsQueryable();
  </code></pre>
  
  <p>Can somebody help pls?</p>