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

1 vote141 views1 answer
Unity up arrow input
C#Unity
-1 vote93 views1 answer
C# The request was aborted: Could not create SSL/TLS secure
C#
0 vote100 views1 answer
Gcm_sender_id convert text
C#
1 vote145 views1 answer
Unity check if a animator parameter trigger is activated
C#Unity
15 votes104 views2 answers
How to play animation with code in unity
C#
7 votes93 views2 answers
C# randomize a list
C#
2 votes135 views1 answer
Unity check for internet connection
C#Unity
0 vote144 views1 answer
C# nunit initialize variables
C#
0 vote109 views1 answer
Advance C# tricks and hits
C#
1 vote96 views1 answer
Teleport in vue
C#