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 vote237 views1 answer
Unity add explosion force
C#Unity
3 votes242 views1 answer
Unity get speed of object
C#
4 votes255 views2 answers
C# how do you check if a string contains only digits
C#
0 vote258 views1 answer
Timer unity
C#Unity
2 votes233 views6 answers
Linq where
C#
0 vote229 views1 answer
Gravity script unity
C#
0 vote225 views1 answer
Convert relative path to physical path c#
C#
1 vote235 views1 answer
C# AllowSynchronousIO to true
C#
0 vote277 views1 answer
Nuget package TSETMC guide
C#
0 vote216 views1 answer
An existing connection was forcibly closed by the remote host. .net core
C#