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 vote319 views1 answer
Unity c# find object position in array
C#
0 vote365 views1 answer
Npm install --save vue-route@n
C#
1 vote322 views1 answer
How set format persian data picker to en
C#
2 votes335 views3 answers
Remove multiple items from list c#
C#
10 votes345 views3 answers
How to lock and hide a cursor unity
C#
1 vote408 views1 answer
How to make an object appear and disappear in unity
C#Unity
0 vote396 views1 answer
C# devexpress get foucused dataRow of child gridView
C#
4 votes388 views1 answer
Gameobject in unity c#
C#Unity
1 vote330 views1 answer
Unity text display int
C#
0 vote355 views1 answer
Pem file string reader c#
C#