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 vote343 views1 answer
Usermanager find based on role
C#
11 votes323 views1 answer
C# list to string comma separated
C#
1 vote355 views2 answers
Unity sort a list
C#Unity
6 votes362 views1 answer
C# get executable path
C#
14 votes381 views3 answers
C# add list to list
C#
0 vote340 views1 answer
Get web api relative path
C#
0 vote382 views1 answer
Unity NetworkBehaviour the type or namespace could not be found
C#Unity
0 vote416 views1 answer
Unity string lowercase
C#Unity
0 vote303 views1 answer
C# silent execute exe
C#
0 vote356 views1 answer
Anonymous class c#
C#