title: Need To Return GroupBy Data With Counts But Selecting Multiple Fields Using LINQ
body: <p>Okay, I'm sure this is simple for someone but it is starting to cause me to tear my hear out so I apologise in advance if this seems like a simple question:</p>
  
  <p>I have the following class:</p>
  
  <pre><code>Public Class Ticket
      Public Property ticket_id As String
      Public Property ticket_assignee As String
      Public Property ticket_email As String
  End Class
  </code></pre>
  
  <p>I am trying to use LINQ to group my list by the <code>ticket_email</code> field but allow me to get the <code>ticket_assignee</code> field and count of each group.</p>
  
  <p>So for example:</p>
  
  <p>For each email address, return me the assignee name and how many tickets in that email group like below:</p>
  
  <pre><code>'fred@someplace.com' = Fred, 4
  'joe@someplace.com' = Joe, 2
  'bob@someplace.com' = Bob, 8
  </code></pre>
  
  <p>etc...</p>
  
  <p>I am still trying to get my head around LINQ and would love to understand it more.  Any help would be appreciated thankyou.</p>