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 vote198 views1 answer
Unity nested list
C#Unity
0 vote171 views1 answer
Unity I run exe second monitor
C#
50 votes154 views4 answers
Loadscene unity
C#
0 vote200 views1 answer
Get parent name unity for inspector
C#Unity
0 vote192 views1 answer
Code to disable Debug.log
C#
2 votes142 views1 answer
C# list.foreach
C#
2 votes131 views1 answer
Unity ray from mouse position
C#
18 votes171 views4 answers
C# messagebox yes no
C#
-1 vote153 views1 answer
Urp set postprocessing value
C#
0 vote184 views1 answer
Play sound in sequence unity
C#Unity