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 vote311 views1 answer
Xamarin forms uwp button hover
C#
1 vote261 views1 answer
How set element in middle in bootstrap
C#
8 votes289 views3 answers
C# increment by 1
C#
34 votes272 views6 answers
Most wishlisted games on steam
C#
7 votes351 views2 answers
How to reference text mesh pro unity
C#
3 votes289 views1 answer
Check connection c#
C#
0 vote299 views1 answer
Dapper Get
C#
0 vote311 views1 answer
Dapper c# insert range
C#
0 vote273 views1 answer
C# getting response content from post
C#
0 vote297 views1 answer
Commandline to open outlook minimized
C#