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

23 votes105 views2 answers
Unity serializefield
C#
1 vote113 views1 answer
How to change a string variables value c#
C#
0 vote122 views1 answer
Defaultconnection appsettings.json
C#
0 vote103 views1 answer
Unity get max occurrence in list
C#
0 vote74 views1 answer
Ef core count
C#
0 vote128 views1 answer
Winforms C# code cross thread operation is not valid
C#
24 votes152 views3 answers
How to get an child of an gameobject
C#
3 votes122 views2 answers
If string contains number c#
C#
0 vote118 views1 answer
C# timer single tick
C#
11 votes114 views2 answers
Unity raycast 2d
C#