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 vote108 views3 answers
Shell32.dll c# example
C#
0 vote139 views1 answer
Update listbox using class c#
C#
10 votes106 views2 answers
C# get size of file
C#
2 votes124 views2 answers
C# create a json object
C#
13 votes111 views1 answer
What does static mean in c#
C#
0 vote113 views1 answer
Asp.netcore: develop on win10 run on ubuntu
C#
2 votes98 views1 answer
C# mvc return partial view
C#
0 vote112 views1 answer
Technische vragen c#
C#
1 vote112 views1 answer
Oncollisionenter is declared but never used
C#
-1 vote109 views1 answer
Asp.net c# set session timeout
C#