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

15 votes136 views3 answers
About unity's particle system
C#
0 vote127 views1 answer
How to convert pdfdocument to binary in c#
C#
0 vote187 views1 answer
Unity script template folder
C#Unity
2 votes89 views1 answer
Sconvert string to title case + C3
C#
0 vote119 views1 answer
Button Previous for picturebox c#
C#
0 vote127 views1 answer
C# string replace multiple matches with one charactar
C#
1 vote216 views2 answers
C# get application root path directory
C#
0 vote124 views1 answer
How to add to a list only items that are not already in the list c#
C#
4 votes134 views1 answer
C# convert Unix time in seconds to datetime
C#
0 vote114 views1 answer
Building a config object in XML C#
C#