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

13 votes344 views2 answers
Boostrap 4 modal
C#
0 vote356 views1 answer
Scale curve revit api
C#
2 votes349 views1 answer
C# get last array element
C#
0 vote343 views2 answers
Unity timer
C#Unity
0 vote327 views1 answer
How to get key value from json object in c#
C#
0 vote382 views1 answer
Nuget package TSETMC guide
C#
1 vote341 views2 answers
C# bool to int
C#
-5 votes355 views5 answers
Happy New Year!
C#
0 vote333 views1 answer
C# task call more web api in parallel
C#
0 vote340 views1 answer
Dxf read c#
C#