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 vote170 views1 answer
Unity trigger not detecting collision
C#
0 vote164 views1 answer
##########
C#
2 votes174 views1 answer
Add a dictionary to another dictionary c#
C#
0 vote181 views1 answer
C# list with only unique items
C#
17 votes218 views3 answers
Unity get list of children
C#Unity
13 votes175 views2 answers
C# list to array
C#
9 votes231 views2 answers
How to change textMesh Pro unity
C#Unity
0 vote206 views1 answer
Php encrypt message encrypt() decrypt
C#
0 vote129 views1 answer
How to convert a key state to a letter in monogame
C#
32 votes323 views4 answers
How to get keyboard input in unity
C#Unity