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 vote153 views1 answer
Unity upload image to project
C#Unity
39 votes117 views3 answers
C# dictionary loop key value
C#
2 votes107 views1 answer
C# resize image keep aspect ratio
C#
0 vote111 views1 answer
.net core executenonqueryasync transaction
C#
1 vote130 views1 answer
Change vignette intensity unity
C#Unity
2 votes133 views2 answers
Unity rotate around axis
C#Unity
11 votes96 views1 answer
Random() C# grepper
C#
0 vote104 views1 answer
C# fold list
C#
0 vote134 views1 answer
Restart animation unity
C#Unity
1 vote155 views1 answer
Unity knowing when 0 input is pressed
C#Unity