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 vote232 views1 answer
Unity enable hdr picker
C#Unity
2 votes214 views1 answer
How to reference scripts in other scenes unity
C#
47 votes273 views6 answers
C# print console
C#
0 vote219 views1 answer
No context type was found in the assembly enable-migrations
C#
0 vote248 views1 answer
Turn list of string to csv c#
C#
0 vote223 views1 answer
How to create vg in aix
C#
7 votes208 views2 answers
C# Remove String In C#
C#
0 vote241 views1 answer
How to make a block disappear in unity
C#Unity
2 votes210 views1 answer
Remove a specific line in richtextbox c#
C#
5 votes226 views1 answer
Unity createassetmenu
C#Unity