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 vote132 views1 answer
C# create a dummy class
C#
0 vote117 views1 answer
Vb.net array search
C#
1 vote127 views2 answers
Should i learn c #
C#
0 vote128 views1 answer
C# asp.net gridview selected row unselect
C#
0 vote162 views1 answer
Unity run all interfaces
C#Unity
0 vote150 views1 answer
Save string unity
C#Unity
2 votes160 views1 answer
Unity 2d how to set an object or the mouse position
C#Unity
0 vote112 views2 answers
Reflection get enum value C#
C#
0 vote201 views1 answer
Asserting exceptions c#
C#
0 vote153 views1 answer
Unity set sprite image from script
C#Unity