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

0 vote149 views2 answers
Create viewport revit api
C#
1 vote136 views1 answer
Throw grenade again csgo
C#
0 vote135 views4 answers
Hovercraft Physics in Unity
C#
0 vote132 views1 answer
Process start web document
C#
0 vote140 views1 answer
Unity restore deleted files
C#
3 votes126 views1 answer
C# list all files in a directory and subdirectory
C#
0 vote128 views1 answer
Xmldocument to c# object
C#
0 vote142 views1 answer
How to move the camera rotation in phone in c# by touch
C#
0 vote134 views1 answer
Wpf settings core
C#
0 vote155 views1 answer
Remove numericUpDown white space
C#