title: Distinct Query?
body: <p>I have a table that contains a Column with client names.  It has about 10-15 distinct clients that appear multiple times in the column.  Is there a way that I can run a query that will list all the distinct clients and do the count for each client so that it shows how many times each client appears in the column?  I know that in SQL you can use as to assign temporary column, but I'm new to LINQ and have no idea if this is possible.</p>
  
  <p>Any help would be great, thanks.</p>