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 vote348 views1 answer
Set data annotation in model c#
C#
2 votes316 views1 answer
Photon how to destroy object
C#
4 votes279 views1 answer
C# .NET Core linq Distinct
C#
0 vote298 views1 answer
Print text c# unity
C#
0 vote329 views2 answers
Get first and last item list c#
C#
4 votes337 views3 answers
Convert comma separated string to array c#
C#
0 vote319 views1 answer
How to get the dynamic year for your web app in mvc
C#
0 vote333 views1 answer
Params keycord as var name c#
C#
0 vote325 views1 answer
C# start file
C#
0 vote326 views1 answer
Compute shader.setfloat(string name, val) error
C#