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 vote237 views1 answer
C# 2 timespan return yesterday
C#
4 votes282 views2 answers
Ontriggerenter2d
C#
2 votes286 views1 answer
Unity run void from another script
C#Unity
0 vote239 views1 answer
Pyautopgui erros
C#
4 votes202 views1 answer
Unity get animator
C#Unity
5 votes235 views1 answer
Check if string is email c#
C#
0 vote231 views1 answer
C# webclient immitate browser
C#
59 votes268 views3 answers
C# date format
C#
1 vote256 views1 answer
C# unity change key input in inspector
C#
3 votes236 views2 answers
Get property value from object c#
C#