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

6 votes181 views6 answers
Rigidbody velocity
C#
0 vote187 views1 answer
Web.config customerrors not working
C#
22 votes181 views3 answers
Change scene unity
C#
7 votes183 views1 answer
Convert system.byte a string c#
C#
0 vote186 views2 answers
C# program exit
C#
0 vote180 views1 answer
Barcode print c#
C#
0 vote232 views2 answers
C# linq query map to entity
C#
0 vote177 views1 answer
Batchblock timeout
C#
7 votes213 views1 answer
Random value in array c#
C#
2 votes186 views10 answers
Format of money value in c#
C#