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 vote274 views1 answer
C# treeview keep selected node highlight
C#
2 votes251 views2 answers
C# loop backwards
C#
-1 vote269 views1 answer
Unity check if colliders are touching
C#Unity
0 vote248 views2 answers
Wpf yes no message box exit
C#
1 vote254 views1 answer
Animations for pause menu
C#
0 vote259 views1 answer
Install Mono project on Ubuntu 20.04
C#
0 vote236 views1 answer
Csharp test for null
C#
0 vote246 views1 answer
Get current location latitude and longitude in xamarin - NAYCode.com
C#
2 votes252 views1 answer
How to move mouse in game c#
C#
0 vote226 views1 answer
Entity framework linq join two tables
C#