Explain the implications of Client vs Server Evaluation in EF Core.

EF Core attempts to evaluate all LINQ queries on the server (database). If it cannot translate a C# construct, it may evaluate it on the client (RAM), severely impacting performance.

In older EF Core versions, implicit client-side evaluation caused massive data downloads. Modern EF Core throws an exception if a query cannot be fully translated to SQL. However, the final Select() projection can execute client-side code (e.g., string formatting). Understanding the boundary between what hits the DB and what hits the CPU is crucial.