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

3 votes141 views1 answer
Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
C#
0 vote211 views1 answer
Get name of project c# .net
C#
0 vote188 views3 answers
Windows forms link listbox to array
C#
4 votes214 views1 answer
How to get rigidbody speed in unity
C#Unity
121 votes541 views6 answers
Random number generator c#
C#
38 votes517 views3 answers
Unity get mouse position
C#Unity
24 votes239 views4 answers
Pop up element from specific index in array
C#
0 vote194 views3 answers
C# encrypt folder SHA512
C#
1 vote219 views1 answer
List all files in directory and subdirectories c#
C#
0 vote181 views1 answer
Compact in laravrl
C#