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

8 votes300 views1 answer
Unity get number of child objects
C#Unity
9 votes178 views2 answers
C# check if string is all numbers
C#
0 vote181 views1 answer
Linq string comparison case insensitive
C#
10 votes224 views4 answers
C# shuffle list
C#
0 vote177 views1 answer
C# fold list
C#
2 votes185 views2 answers
C# csv read write
C#
0 vote168 views1 answer
C# downloadstirng download old
C#
0 vote172 views1 answer
Npm add auth token
C#
0 vote275 views1 answer
C# function<T>
C#
0 vote175 views1 answer
C# get the return value of a func
C#