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 vote139 views1 answer
Get android model adb
C#
0 vote185 views1 answer
How to write boolean condition in if statement at c#
C#
1 vote164 views2 answers
No context type was found in the assembly
C#
0 vote141 views1 answer
C# Returning Strings
C#
0 vote127 views1 answer
How to print a matrix in c#
C#
0 vote167 views1 answer
How to add a variable in unity c#
C#Unity
0 vote142 views1 answer
Serenity.is required field
C#
0 vote136 views1 answer
Get array from column datatable c#
C#
4 votes223 views3 answers
Public gameobject unity
C#Unity
0 vote123 views1 answer
C# Custom setter with parameter
C#