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

4 votes108 views1 answer
How to change the color of your text in c#
C#
0 vote75 views1 answer
Unity insert variable into string
C#
5 votes145 views2 answers
Rigidbody velocity c# unity
C#Unity
0 vote125 views1 answer
Telerik wpf gridviewcombobox itemsource property on item
C#
0 vote119 views1 answer
C# replace crlf
C#
2 votes102 views1 answer
Write string multiple times c#
C#
0 vote114 views1 answer
Make tooltip disappear c#
C#
1 vote122 views2 answers
Difference between iqueryable and ienumerable c#
C#
2 votes111 views1 answer
C# how to use inovke
C#
3 votes120 views3 answers
C# Letters Only
C#