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

27 votes181 views10 answers
Google translate
C#
0 vote253 views1 answer
Make random alphabet in c#
C#
13 votes305 views3 answers
Java.sql.sqlexception: access denied for user 'root'@'localhost' (using password: no)
C#
0 vote230 views1 answer
C# program lambda Func
C#
0 vote212 views1 answer
Générer un nombre aléatoire en c#
C#
0 vote241 views1 answer
How to tell visual studio that you're using unity
C#Unity
9 votes261 views3 answers
Find gameobject unity
C#Unity
0 vote276 views1 answer
Vb.net check if datatable has rows
C#
0 vote186 views1 answer
C# How to change the text colour?
C#
47 votes220 views6 answers
C# print console
C#