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

4 votes174 views3 answers
Public gameobject
C#
2 votes164 views1 answer
C# add to start of list
C#
0 vote161 views1 answer
Ssml
C#
1 vote225 views1 answer
Xamarin.Forms - How to navigate to a tabbed page child page
C#
16 votes167 views2 answers
Import time C#
C#
7 votes187 views2 answers
Set focus ui unity
C#Unity
0 vote221 views1 answer
New texture unity
C#Unity
2 votes166 views10 answers
Lol
C#
0 vote159 views1 answer
Datetime in specific format c#
C#
0 vote207 views1 answer
Wait in void update in unity
C#Unity