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

92 votes405 views5 answers
C# random number between
C#
0 vote380 views1 answer
How to set the value of a textbox textmode=date asp.net c#
C#
0 vote345 views1 answer
Update postgres sequence to max
C#
0 vote390 views1 answer
C# calculate sum of list
C#
1 vote386 views1 answer
Merge point
C#
9 votes354 views3 answers
Get rigidbody component unity
C#
0 vote339 views1 answer
Asp.net mvc get current url in view
C#
9 votes420 views1 answer
Discord bot status code c#
C#
1 vote406 views1 answer
Unity get script from gameobject
C#Unity
0 vote360 views1 answer
Concatenation on different lines in f#
C#