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 vote146 views1 answer
C# string replace multiple matches with one charactar
C#
0 vote157 views1 answer
How to invoke an AWS Lambda function asynchronously
C#
1 vote136 views3 answers
And operator in c#
C#
1 vote101 views1 answer
C# ping
C#
4 votes142 views2 answers
Vector3 to quaternion C#
C#
0 vote178 views1 answer
How do you make a 2D object follow another 2D object in unity 2D
C#Unity
1 vote135 views1 answer
The type or namespace name 'Scrollbar' could not be found
C#
0 vote144 views3 answers
C sharp convert string time into 24 hours time
C#
24 votes134 views3 answers
How to print statement in c#
C#
0 vote146 views2 answers
How to close another app in system with c#
C#