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 vote142 views3 answers
C# code examples
C#
0 vote202 views1 answer
1/1/1/1/1
C#
0 vote173 views2 answers
Create viewport revit api
C#
0 vote173 views2 answers
C# for loop Statement
C#
0 vote151 views1 answer
Autho close in persian time picker
C#
0 vote140 views1 answer
Go to the corresponding brace visual studio C#
C#
0 vote222 views1 answer
Pick random point inside box collider unity
C#Unity
0 vote142 views1 answer
Connect to a database and loop over a recordset in C#
C#
0 vote318 views1 answer
How to import forgerock sdk in c#
C#
0 vote164 views1 answer
Php encrypt message encrypt() decrypt
C#