/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

1 vote361 views1 answer
Unity main texture not working
C#
1 vote329 views1 answer
West of loathing
C#
0 vote336 views1 answer
Convert-integer-to-binary-in-c-sharp
C#
0 vote394 views1 answer
For loop cs
C#
0 vote308 views1 answer
Visual studio console.writeline not showing in output window
C#
0 vote336 views1 answer
Conevrt list to pipe separated string c#
C#
0 vote312 views1 answer
The anti-forgery cookie token and form field token do not match.
C#
6 votes329 views1 answer
C sharp check if key in dictionary
C#
0 vote312 views1 answer
Flyt wordpress fra localserver
C#
4 votes312 views1 answer
How ot make a variable public without showing in the inspector
C#