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 vote251 views1 answer
C# postmessage mouse click
C#
-2 votes295 views1 answer
Unity input tastiera
C#Unity
0 vote297 views1 answer
Check if process is open c#
C#
3 votes292 views1 answer
Unity new Color()
C#
8 votes259 views1 answer
Guid.empty
C#
0 vote293 views1 answer
Unity predicts rigidbody position in x seconds
C#Unity
1 vote273 views1 answer
C# count specific element in list
C#
0 vote269 views1 answer
Align String with Spaces [C#]
C#
0 vote276 views1 answer
C# add \ in a string without escaping
C#
26 votes302 views4 answers
Unity print
C#Unity