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

21 votes296 views8 answers
Translator
C#
0 vote286 views1 answer
C# datagridview cell click event
C#
0 vote279 views1 answer
C# The name `Math' does not exist in the current contex
C#
0 vote294 views1 answer
How to convert float to int in c# unity
C#
0 vote256 views1 answer
Precision comparison in C#
C#
11 votes256 views4 answers
Loop through string array c#
C#
21 votes276 views2 answers
Random.range unity
C#
0 vote259 views1 answer
C# Case insensitive Contains(string)
C#
2 votes274 views6 answers
Linq where
C#
0 vote300 views1 answer
For what is percent sign in unity c#
C#Unity