Subquery in LInQ EF Core C#

var accountBalance = context
    .AccountBalanceByDate
    .Where(a => 
        a.Date == context.AccountBalanceByDate
             .Where(b => b.AccountId == a.AccountId && b.Date < date).Max(b => b.Date));

Source: stackoverflow.com

Similar codes

0 vote379 views1 answer
Upgrade asp.net core to 5.0
C#
0 vote447 views1 answer
Unity stop all audio
C#Unity
6 votes369 views2 answers
C# float to string with 2 decimals
C#
0 vote324 views1 answer
C# copy each property
C#
0 vote341 views1 answer
Getname of month from date c#
C#
1 vote345 views2 answers
C# convert bitmap to image
C#
0 vote359 views1 answer
Cannot resolve scoped service 'Mango.Services.Identity.Initializer.IDbInitializer' from root provider
C#
0 vote386 views1 answer
Entity framework core
C#
0 vote369 views1 answer
Dotnet DB context register
C#
0 vote391 views1 answer
Unity quit in edtor
C#Unity