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 vote173 views1 answer
C# load form
C#
1 vote246 views1 answer
How to convert nullable datetime datarow to datetime in c#
C#
0 vote179 views1 answer
C# map number range
C#
0 vote160 views1 answer
C# listview add items horizontally
C#
0 vote165 views4 answers
What are delegates and how to use them c#
C#
1 vote176 views1 answer
Get 2d rotation from 2 position math
C#
0 vote239 views1 answer
Make random alphabet in c#
C#
2 votes225 views1 answer
Scene switch unity
C#Unity
4 votes183 views3 answers
Public gameobject
C#
0 vote189 views1 answer
C# for loop next iteration
C#