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 vote270 views2 answers
C# wpf control to windw size
C#
30 votes338 views3 answers
How to create a list in c# unity
C#Unity
0 vote265 views1 answer
C# foreach char in string
C#
2 votes319 views1 answer
Unity 2d how to set an object or the mouse position
C#Unity
38 votes469 views3 answers
Unity get mouse position
C#Unity
0 vote285 views1 answer
Access label from another class c#
C#
0 vote294 views1 answer
Handle several buttons' click events
C#
1 vote326 views2 answers
Restart level unity
C#Unity
0 vote302 views1 answer
Unity get quaternion z
C#Unity
0 vote289 views1 answer
C# itext 7 PdfDocument from byte array
C#