Horje
converting dens_rank and row_number to linq Code Example
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")....




Csharp

Related
Filling a DataSet or a DataTable from a LINQ query result set C# Code Example Filling a DataSet or a DataTable from a LINQ query result set C# Code Example
itext7 c# memorystream Code Example itext7 c# memorystream Code Example
c# ? behind variable Code Example c# ? behind variable Code Example
c# xamarin forms  use AssetManager to get text file Code Example c# xamarin forms use AssetManager to get text file Code Example
Close Form After fixed time Code Example Close Form After fixed time Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
8