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 vote237 views1 answer
Unity 2D mouse look at cursor
C#Unity
-1 vote209 views1 answer
Dotnet
C#
2 votes195 views1 answer
C# get last array element
C#
0 vote184 views1 answer
C# get process file location
C#
0 vote227 views1 answer
C# system dont let write txt file
C#
0 vote184 views1 answer
Metadata publishing for this service is currently disabled
C#
5 votes195 views1 answer
Load prefab in script unity
C#
2 votes237 views2 answers
HCF of number
C#
1 vote238 views1 answer
Unity change tag of go
C#Unity
0 vote236 views1 answer
Unity sprite disappears when using transform.lookat
C#Unity