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 vote228 views2 answers
Asp net identity login failed for user
C#
0 vote201 views1 answer
How to add an embedded resource in visual studio code
C#
0 vote190 views1 answer
Convert object to xml c# example code
C#
0 vote188 views1 answer
Type already defines a member called 'Get'
C#
0 vote219 views1 answer
Convert rgb to float
C#
0 vote223 views1 answer
Basic auth swagger .net core 5
C#
1 vote201 views2 answers
Get list of months and year between two dates c#
C#
0 vote178 views1 answer
What is the best way to lock cache in asp.net?
C#
4 votes252 views1 answer
How to reference a child object unity
C#Unity
-1 vote190 views1 answer
C# file directory selection
C#