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

2 votes274 views2 answers
C# clear a textbox
C#
0 vote264 views1 answer
.net framework get configuration value from web.config
C#
1 vote320 views1 answer
Unity3d quaternion add 90 degrees
C#
0 vote269 views1 answer
Instantiate an object at a certain position unity
C#
14 votes272 views2 answers
How to move player with transform. position
C#
0 vote294 views1 answer
Remove carriage returns from string c#
C#
0 vote275 views1 answer
Wpf label content nullpointerexception
C#
0 vote306 views1 answer
Write last element of dictionary c#
C#
0 vote296 views1 answer
Gcm_sender_id convert text
C#
0 vote282 views1 answer
Web.config customerrors not working
C#