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 vote252 views1 answer
C# check something is string
C#
1 vote212 views2 answers
Insert SQLite
C#
2 votes221 views2 answers
Get Properties of a Class
C#
174 votes335 views6 answers
C# foreach
C#
-1 vote235 views1 answer
C# for loop last iteration
C#
0 vote230 views1 answer
Unity aspect ratio
C#
0 vote208 views1 answer
Create new .net core project visual studio
C#
0 vote250 views1 answer
Unity c# public all codes
C#Unity
1 vote236 views1 answer
Unity get script from gameobject
C#
40 votes224 views2 answers
C# string split by length
C#