How to calculate rank from list of integer?

Question

In database(SQL Server), say, one column values are like:

Col1
====
10
5
15
20
5
10
2

This is like list of integer data.

Rank should be:

Col1 Rank
==== ====
20    1
15    2
10    3
10    3
5     4
5     4
2     5

I have tried in following manner:

1) First sort the list of data in descending order of "Col1" value
2) Find the index of a particular record using FindIndex() method.
3) Then Rank = Index + 1

But it will only work if the data are unique. It fails when same "Col1" values are present in multiple rows as the index is returning 0, 1, 2, 3, 4, 5, 6.

How to calculate the rank when the list contains data which are not distinct(in most cases!) using C# LINQ?

Answer 1

Why not do it in the database?

SELECT [Col1], DENSE_RANK() OVER (ORDER BY Col1 DESC) AS [Rank]
FROM Table

But if you must do it in C#

var data = new List<int>();
var rankings = data.OrderByDescending(x => x)
                   .GroupBy(x => x)
                   .SelectMany((g, i) =>
                       g.Select(e => new { Col1 = e, Rank = i + 1 }))
                   .ToList();