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

7 votes206 views2 answers
C# randomize a list
C#
0 vote239 views1 answer
Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.
C#
0 vote210 views1 answer
Avoid auto-filling persian time picker
C#
8 votes220 views2 answers
Unity respawn
C#
0 vote216 views1 answer
Poems
C#
0 vote208 views1 answer
Dataannotations for currency in c#
C#
2 votes226 views1 answer
C# create new thread
C#
0 vote221 views1 answer
Getting the ID of the element that fired an event
C#
0 vote203 views1 answer
Push vaiable in array c#
C#
2 votes195 views1 answer
Headless chromedriver C#
C#