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

1 vote179 views1 answer
How to allow user import image c#
C#
0 vote119 views1 answer
.Net Core Bundling & minification 02 : .net core The name 'Scripts' does not exist in the current context
C#
0 vote127 views1 answer
C# open access database mdb
C#
-2 votes136 views2 answers
Calculate time difference with now in flutter
C#
0 vote127 views1 answer
Make character move upward forever unity 2d
C#
0 vote128 views1 answer
Asp.net throw unauthorized exception
C#
0 vote122 views1 answer
C# performance timer
C#
65 votes173 views6 answers
Unity reload scene
C#
0 vote123 views1 answer
Windows 10 see how long a program has been running
C#
32 votes135 views6 answers
Random String
C#