Distinct Query? <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>