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

3 votes243 views1 answer
Unity on mousewheel down
C#Unity
0 vote242 views1 answer
Check if process is open c#
C#
4 votes189 views1 answer
C# loop datatable rows
C#
6 votes145 views1 answer
Movement slowly towards target unity
C#
0 vote259 views1 answer
Moq set delay to return
C#
0 vote270 views1 answer
Unity enable hdr picker
C#Unity
0 vote251 views1 answer
Unity Interstitial ad C#
C#Unity
4 votes252 views1 answer
Unity play particle system
C#Unity
1 vote233 views1 answer
Struct constructor c#
C#
0 vote310 views1 answer
Unity matchinfo
C#Unity