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

3 votes135 views1 answer
Unity how to rotate something to point to something else
C#Unity
0 vote102 views1 answer
C# serialize to xml
C#
18 votes100 views4 answers
C# iterate enum
C#
1 vote139 views1 answer
Vector3.signedangle not showin singed angle in unity
C#Unity
0 vote141 views1 answer
Unity gameobject visible to specific camera
C#Unity
2 votes102 views1 answer
C# write byte[] to stream
C#
0 vote99 views1 answer
How to pass optional guid parameters in c#
C#
1 vote99 views1 answer
Getting the row of max value c# linq
C#
4 votes85 views3 answers
C# clear an array
C#
0 vote94 views1 answer
If checkbox checked in c#
C#