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

2 votes170 views1 answer
C# get certain character from string
C#
65 votes559 views6 answers
Unity reload scene
C#Unity
2 votes151 views1 answer
Find largest number in array c#
C#
0 vote169 views1 answer
Print the top view of the binary tree
C#
0 vote165 views1 answer
How to store more precise data then float c#
C#
0 vote193 views1 answer
How disable the back off a panel C#
C#
1 vote224 views1 answer
How to spawn coins randomly around the screen unity 2d
C#Unity
1 vote164 views1 answer
How can you learn C# on your own
C#
31 votes164 views4 answers
Unity check if space pressed
C#
0 vote163 views1 answer
C# .net stringify data query
C#