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 vote197 views1 answer
Eleventy set default layout
C#
-1 vote173 views1 answer
Load Level Action for unity
C#
0 vote201 views1 answer
C# convert datetime to unix timestamp
C#
0 vote171 views1 answer
Unity respawn c#
C#
0 vote196 views1 answer
Create instance of class given class name string c#
C#
0 vote247 views1 answer
Stuck.hypixel.net ip
C#
1 vote180 views3 answers
Sort a dictionary by value in c#
C#
9 votes192 views2 answers
C# calculate difference between two dates in days
C#
0 vote202 views1 answer
Run async method parallel c#
C#
0 vote221 views2 answers
Int array to frequency dictionary c#
C#