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

1 vote314 views1 answer
Dell
C#
13 votes310 views5 answers
C# list to string
C#
1 vote301 views1 answer
How to declare an dinamic array in c#
C#
1 vote308 views1 answer
Unity put children in list
C#
13 votes335 views2 answers
C# list to array
C#
0 vote315 views1 answer
Convert list of tuples to dictionary c#
C#
9 votes365 views2 answers
Quit button unity
C#Unity
1 vote362 views1 answer
How to cast list to observablecollection c#
C#
2 votes296 views1 answer
Scene switch unity
C#
0 vote329 views1 answer
Discord embeds how to separate inline fields
C#