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

0 vote178 views1 answer
Auto paly a video control in mvc c#
C#
3 votes188 views2 answers
How to add a force to an object unity
C#
7 votes155 views2 answers
C# Remove String In C#
C#
0 vote168 views1 answer
If char is upper csharp
C#
-1 vote182 views1 answer
Select records that does not exist in another table in Entity Framework
C#
0 vote180 views1 answer
C# check if object can be cast to type
C#
0 vote172 views1 answer
C# download string url
C#
5 votes170 views1 answer
Downlaod file and use C#
C#
0 vote182 views1 answer
ASP.net ApplicationUser referance not found
C#
1 vote158 views1 answer
Unity C# catch index out or range exception
C#