/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

0 vote100 views1 answer
Php encrypt message encrypt() decrypt
C#
0 vote151 views1 answer
Allow scroll with wheel mouse datagridview c#
C#
0 vote101 views1 answer
How to open onscreen keyboard c#
C#
0 vote126 views1 answer
Delayed function unity
C#Unity
0 vote134 views1 answer
C# second last index
C#
0 vote101 views1 answer
An unhandled exception of type 'System.ArgumentException' occurred in System.Private.Xml.dll: 'The node to be inserted is from a different document context
C#
0 vote99 views1 answer
C# check if object is of any generic type
C#
21 votes103 views2 answers
Press key run code unity c#
C#
3 votes96 views2 answers
C# multiply string
C#
-1 vote94 views1 answer
C# windows forms function after load
C#