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 vote168 views1 answer
.net ssh, wait command execute
C#
0 vote196 views1 answer
Log4net.config configuration
C#
0 vote167 views1 answer
Dotnet build command
C#
2 votes153 views1 answer
How to insert into a list c#
C#
1 vote191 views2 answers
Int to bool c#
C#
0 vote151 views1 answer
C# xamarin forms use AssetManager to get text file
C#
6 votes134 views1 answer
Find substring index in string c#
C#
0 vote167 views1 answer
How to remove from list from index c#
C#
0 vote222 views1 answer
How to get point of collision in unity
C#Unity
6 votes164 views2 answers
C# float to string with 2 decimals
C#