First of all the SQL statement looks a bit odd. The idea in GROUP BY is that you define all the columns that are used to define a unique combination of data in a group. Then again you can select these columns in the SELECT clause and use aggregates on other columns. Because of this an asterisk (*) doesn't make sense in the query.
So to include all desired columns, use column names instead of asterisk in both SQL statement and in the LINQ query.
See
SQL GROUP BY Statement[
^] and
How to: Handle Composite Keys in Queries[
^]