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

1 vote302 views1 answer
Check valid binary search tree java
C#
5 votes310 views1 answer
If unity
C#
0 vote336 views2 answers
How to loop through a list and skip first element in c#
C#
0 vote290 views1 answer
How to check if list index is out of range in c#
C#
5 votes292 views3 answers
C# char input
C#
0 vote270 views1 answer
Radiobutton in asp.net
C#
1 vote274 views1 answer
Mvc foreach
C#
12 votes298 views3 answers
Quit button unity
C#Unity
8 votes367 views1 answer
Unity get number of child objects
C#Unity
49 votes463 views6 answers
Instantiate unity
C#Unity