1

Possible Duplicate:
SELECT MIN(ZoneMin), MAX(ZoneMin) FROM Plant as LINQ to SQL

I'm trying to create a LINQ expression with two aggregate operators.

How should the LINQ expression be for the following SQL query:

SELECT TOP 10 PlayerId, Max(Score) AS Score, Min(Name) AS Name FROM Scores
GROUP BY PlayerId
ORDER BY Score DESC

I need as result a list of "Scores" objects.

thanks

Community
  • 1
  • 1
Skuami
  • 1,422
  • 2
  • 14
  • 28

0 Answers0