/C#/Converting dens_rank and row_number to linq

Converting dens_rank and row_number to linq

var result = data.GroupBy(item => new { item.OriginalDocumentNumber, item.FilterRound })
    .OrderBy(@group => @group.First().p2_FinalGrade)
    .AsEnumerable()
    .Select((@group, groupIndex) => new
    {
        Items = @group.Select((item, index) => new { Item = item, Index = ++index }),
        Rank = ++groupIndex
    })
    .SelectMany(v => v.Items, (s, i) => new
    {
        Data = i.Item,
        RankInGroup = i.Index,
        DenseRank = s.Rank
    }).ToList();

result.Where(item => item.Data.p2_FinalGrade == "d" ||
                        item.Data.p2_FinalGrade == "f")
      .Where(item => item.Data.OriginalDocumentNumber == "590200054")....

Source: stackoverflow.com

Similar codes

3 votes386 views1 answer
Unity mouse scroll wheel axis
C#Unity
1 vote369 views1 answer
Unity load current scene
C#
0 vote339 views1 answer
What is napalm made of
C#
0 vote345 views1 answer
C# xml comment type reference
C#
0 vote342 views1 answer
Unable to resolve service for type 'microsoft.aspnetcore.identity.rolemanager`1
C#
0 vote353 views1 answer
C# Program For Check Total Occurrence Of A Number In An Array
C#
6 votes373 views2 answers
Unity copy to clipboard
C#
0 vote384 views2 answers
Mydata api .net
C#
0 vote337 views1 answer
How to get total scenes unity
C#
8 votes354 views1 answer
Lockstate untiy
C#