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

2 votes275 views2 answers
Thread c#
C#
0 vote258 views1 answer
How to check if the value is alphabet only in c#
C#
0 vote249 views1 answer
Datetime in specific format c#
C#
0 vote262 views1 answer
Trygetvalue dictionary c# example
C#
3 votes230 views1 answer
How to start a coroutine in c#
C#
25 votes255 views3 answers
If get key down unity
C#
0 vote277 views1 answer
Unity lerp position
C#Unity
1 vote253 views1 answer
What is type unity
C#
0 vote255 views1 answer
C# add multiple items to list
C#
0 vote275 views1 answer
Unityexception creating asset at path failed
C#