How does LINQ behave under partial query translation failure?

When translation fails, LINQ may throw exceptions or switch parts of the query to client evaluation.

EF Core attempts to translate expression trees fully. If a method or construct cannot be translated, older versions partially evaluated queries on the client, leading to performance issues. Modern EF Core versions often throw exceptions instead to prevent silent inefficiencies. This forces developers to restructure queries for full server execution.