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 votes114 views2 answers
C# Select MSSQL
C#
2 votes117 views2 answers
Validate data exist in database lara vel
C#
0 vote124 views1 answer
How to make panel scrollable c#
C#
1 vote140 views2 answers
C# only letters
C#
0 vote261 views1 answer
How to import forgerock sdk in c#
C#
3 votes138 views1 answer
Unity mouse scroll wheel axis
C#
0 vote112 views1 answer
How to do minus with button c#
C#
22 votes121 views3 answers
Unity change text color
C#
1 vote138 views1 answer
C# datagridview row delete
C#
1 vote144 views2 answers
C# C# read text from a certain line number from string
C#