Order a subquery in linq .include portion

See more:

LINQ

ASP.NET-Core

Hi,

On my very first project on ASP Core I have come across a trouble that strangely has not to have been resolved yet although seems quite simple.

On a details page of an Accounts Model I seek to have the table reflecting balances (transactions) entries, pertaining to the relevant account, in a descending date order:

public async Task<iactionresult> Details(string _SrcSys, string _CustId, string _AccId)
        {
            if (_SrcSys == null || _CustId == null || _AccId == null)
            {
                return NotFound(); // The three are Composite Key elements
            }

            var Accs = await _context.Accounts
                       .Include(Bal => Bal.Balances)
                       .OrderBy(Bal => Bal.Balances.OrderByDescending(x => x.RepDt)) //Why isn't this sorting the result?
                       .SingleOrDefaultAsync(x => x.SrcSys == _SrcSys && x.CustId == _CustId && x.AccId == _AccId);

            return View(Accs);

What could be the error? The portion in simple words is that why doesn't .OrderBy(Bal => Bal.Balances.OrderByDescending(x => x.RepDt)) help in having the balances table be sorted on the Accounts' Details Page?

Please help!

What I have tried:

The code in many shapes and question placed searched on google, but can't find any help.