subquery in LInQ EF Core csharp
Code Example - subquery in LInQ EF Core csharp
var accountBalance = context
.AccountBalanceByDate
.Where(a =>
a.Date == context.AccountBalanceByDate
.Where(b => b.AccountId == a.AccountId && b.Date < date).Max(b => b.Date));