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

9 votes201 views3 answers
Unity how to create 2d object from script
C#Unity
2 votes127 views1 answer
Checkbox value unchecked after return view model
C#
3 votes117 views2 answers
How to add a force to an object unity
C#
1 vote174 views1 answer
Unity3d quaternion add 90 degrees
C#Unity
0 vote130 views1 answer
How to store user input into list c#
C#
0 vote125 views1 answer
C# how to ignore case
C#
1 vote132 views1 answer
Detecting a right click unity
C#
4 votes128 views3 answers
Public gameobject
C#
5 votes130 views1 answer
Downlaod file and use C#
C#
4 votes124 views1 answer
C# check if type implements interface
C#