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 vote285 views2 answers
2d list c#
C#
0 vote258 views1 answer
How to stop timer in c# windows application
C#
1 vote236 views1 answer
How set element in middle in bootstrap
C#
11 votes286 views1 answer
How to make a hello world program in c#
C#
1 vote303 views1 answer
Unity how to move an object to another object
C#Unity
0 vote233 views1 answer
Process.start web
C#
0 vote255 views1 answer
.net core executenonqueryasync transaction
C#
0 vote269 views2 answers
How do I calculate someone's age based on a DateTime type birthday?
C#
2 votes271 views3 answers
Oncollisionenter
C#
1 vote273 views1 answer
Unity ui get the canvas
C#