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 vote127 views1 answer
How to make soft body OBJECT in unity
C#Unity
0 vote112 views2 answers
Docker-compose cassandra db
C#
0 vote90 views1 answer
Assign int value c#
C#
0 vote104 views1 answer
Unity animation length
C#
0 vote129 views1 answer
Freeze scene unity
C#Unity
0 vote103 views1 answer
C# string replace multiple matches with one charactar
C#
0 vote97 views1 answer
C# read excel file into datatable
C#
5 votes105 views1 answer
Open new window c# wpf
C#
0 vote101 views1 answer
Use different database with entitymanagerfactory
C#
0 vote103 views1 answer
All SQL Server Tables in a Schema
C#