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 vote318 views1 answer
How to convert date to Complete ISO-8601 date in c#
C#
0 vote347 views1 answer
Go Statement in CSharp
C#
2 votes374 views1 answer
How to reset rotation in unity
C#Unity
0 vote321 views1 answer
How to add an embedded resource in visual studio code
C#
0 vote333 views1 answer
Get ad user using email address microsoft graph C#
C#
0 vote286 views1 answer
Oldest living language
C#
1 vote335 views1 answer
Get distinct from datatable c#
C#
1 vote330 views1 answer
Get index c#
C#
0 vote344 views1 answer
C sharp tenery operator on an action
C#
13 votes328 views6 answers
Function c#
C#