/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

47 votes144 views5 answers
C# read from file
C#
18 votes194 views1 answer
Unity delete all children
C#Unity
35 votes137 views4 answers
C# string to byte[]
C#
0 vote155 views1 answer
Could not load file or assembly 'Ubiety.Dns.Core, Version=2.2.1.0
C#
2 votes180 views2 answers
Unity scene switch
C#Unity
0 vote141 views1 answer
Create iis website programmatically c#
C#
0 vote148 views1 answer
Unity set sprite image from script
C#
0 vote185 views1 answer
Unity vector3 initialization
C#
0 vote169 views1 answer
C# handle single quote inside string
C#
0 vote136 views1 answer
Do loop c#
C#