EF Core Returns Stale Data After Update in Production: Root Cause and Fix

You update an order status from Pending to Confirmed, call SaveChangesAsync, and get a clean 200 response. The next GET request on that order comes back Pending. You check the database directly — the