Using OrderBy on property that was resolved using double ternary operator.

[cts-tradeit]

Current behaviour

Sample query from DebugView (the query is way bigger but this is the part that causes the problem):

DbSet<AccountingJournal>()
    .Select(journal => new OverviewAccountingJournalMappingSource{ 
        Worker = journal.WorkerAccountingId != null ? <>c__DisplayClass1_0.workers
            .SingleOrDefault(w => w.AccountingId == journal.WorkerAccountingId) : journal.WorkerEnterpriseId != null ? <>c__DisplayClass1_0.workers
            .SingleOrDefault(w => w.EnterpriseId == journal.WorkerEnterpriseId) : null, 
    )
    .Select(dtoOverviewAccountingJournalMappingSource => new OverviewAccountingJournalWebDto{ 
        WorkerSurname = dtoOverviewAccountingJournalMappingSource.Worker.Surname, 
    }
    )
    .OrderByDescending($it => $it.WorkerSurname)
    .ThenBy($it => $it.Id)
    .Skip(TypedLinqParameterContainer<int>.TypedProperty)
    .Take(TypedLinqParameterContainer<int>.TypedProperty)

Produces:
System.InvalidOperationException: The LINQ expression 'DbSet()
.OrderByDescending(a => a.WorkerAccountingId != null ? DbSet()
.Where(w => w.AccountingId == a.WorkerAccountingId)
.SingleOrDefault() : a.WorkerEnterpriseId != null ? DbSet()
.Where(w0 => w0.EnterpriseId == a.WorkerEnterpriseId)
.SingleOrDefault() : null.Surname)' could not be translated

[cts-tradeit]

We suspect that it is caused by it being a double ternary operator as this query containing ternary operator works

DbSet<AccountingJournal>()
    .Select(journal => new OverviewAccountingJournalMappingSource{ 
        Client = journal.ClientAccountingId != null ? <>c__DisplayClass1_0.clients
            .SingleOrDefault(c => c.AccountingId == journal.ClientAccountingId) : null, 
    }
    )
    .Select(dtoOverviewAccountingJournalMappingSource => new OverviewAccountingJournalWebDto{ 
        ClientShortcut = dtoOverviewAccountingJournalMappingSource.Client.Shortcut,     
    }
    )
    .OrderBy($it => $it.ClientShortcut)
    .ThenBy($it => $it.Id)
    .Skip(TypedLinqParameterContainer<int>.TypedProperty)
    .Take(TypedLinqParameterContainer<int>.TypedProperty)

[cts-tradeit]

Provider being used is npgsql.

[roji]

@cts-tradeit please take the time to create a minimal, runnable code sample (e.g. a console program) - the above is a very partial snippet without a full exception etc.