How to make EF core translate custom sort into a plain 'When Then' instead of hierarchical

EF Core could not be translated and will be evaluated locally

ZZZ_tmp

EF core, Any could not be translated and will be evaluated locally

ZZZ_tmp

Write Dynamic LINQ queries for sorting and projecting with EF Core

Trying to get suitable formulations for "inner graph" members is proving difficult....On the basis of prior stack overflow replies, I developed numerous lines of code. But I'm having trouble coming up with a solid "solution approach."...Try expressing "a string" as a lambda field member, for instance....The ToMemberOf extension function that I had ...

How to translate this SQL query to a LINQ query in EF Core?

ZZZ_tmp

EF Core 3.0 translating string.Equals ordinalIgnoreCase correctly

ZZZ_tmp

Entity Framework 3.0 Contains cannot be translated in SQL as it was in EF Core 2.2

ZZZ_tmp

Auto-generated FK relations in EF Core - how to made them non-nullable

ZZZ_tmp

EF Core LINQ Where with extension mehods are not translated to SQL

ZZZ_tmp

EF Core Linq to SQLite could not be translated, works on SQL Server

ZZZ_tmp

EF Core 3.1 doesn't translate with a helper class on querying

ZZZ_tmp