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 vote214 views1 answer
Mouse click unity raycast unity
C#Unity
7 votes173 views1 answer
C# tostring mmm dd yyyy
C#
3 votes168 views2 answers
C# get path without filename
C#
0 vote164 views1 answer
UnityEngine.Mesh:get_vertices()
C#
1 vote173 views1 answer
.net hello world
C#
24 votes171 views3 answers
String to date vb
C#
0 vote175 views1 answer
C# passing function as input delegate
C#
0 vote195 views1 answer
How to keep rigidbody2D upright unity
C#Unity
2 votes191 views1 answer
Set player position unity
C#
3 votes166 views1 answer
Unity transformer double en float
C#