Group by ef core

var query = 
    from ep in dbContext.tbl_EntryPoint
    join e in dbContext.tbl_Entry on ep.EID equals e.EID
    join t in dbContext.tbl_Title on e.TID equals t.TID
    where e.OwnerID == user.UID
    group new { ep, e, t } by new { e.aID, e.bCode, e.Date, e.FCode } into g
    let r = g.OrderByDescending(x => x.e.ID).FirstOrDefault()
    select new
    {
        UID = r.e.OwnerID,
        TID = r.e.TID,
        Title = r.t.Title,
        EID = r.e.EID
    };

Similar codes

1 vote97 views1 answer
Linq c# where condition
C#
0 vote107 views1 answer
Redirect to another controller page in asp.net core
C#
1 vote108 views1 answer
Mvc 5 dropdownlist
C#
0 vote136 views1 answer
Get parent name unity for inspector
C#Unity
0 vote94 views1 answer
A infinite loop in text box update ui c#
C#
1 vote96 views1 answer
How to show the value of a string in c#
C#
0 vote133 views1 answer
Check if object has parent unity
C#Unity
0 vote103 views1 answer
How to make character respawn if touches sprite c#
C#
2 votes143 views1 answer
How to change the position of a gameobject in c# unity
C#Unity
11 votes99 views2 answers
C# messagebox result
C#