Using LINQ to count value frequency
I have a table ID|VALUE VALUE an integer field with possible values 0 - 4. How can I query the count of each value? Ideally the result should be an array with 6 elements, one for the count of each value and the last one is the total number of rows. ...