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 vote177 views1 answer
Dispose await task c#
C#
14 votes242 views2 answers
Unity debug log gameobject
C#Unity
0 vote129 views1 answer
Unity get quaternion z
C#
0 vote139 views1 answer
How return only value of array in laravel
C#
1 vote130 views1 answer
Godot c# export variables
C#
18 votes131 views3 answers
Unity find child by name
C#
0 vote142 views1 answer
Get web config key value in c# razor view
C#
6 votes140 views1 answer
How to change a image with code unity
C#
0 vote190 views1 answer
C# underscore variable
C#
1 vote132 views1 answer
Create new object from generic c#
C#