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

11 votes139 views3 answers
C# unity detect any keyboard input
C#
0 vote135 views2 answers
Facing issue of phone number in csv file c#
C#
0 vote138 views1 answer
Asp.net razor get list without refresh
C#
0 vote126 views1 answer
C# linq remove duplicate items from list of integer
C#
0 vote145 views1 answer
C# remove crlf from string
C#
1 vote141 views1 answer
If number negative c sharp
C#
1 vote154 views1 answer
How to set a transform equal to something unity
C#
2 votes176 views1 answer
Unity unparent
C#Unity
0 vote140 views1 answer
Dictionary.Add values to array c#
C#
0 vote151 views1 answer
.net entities query multiple join condition type inference
C#