@MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, not just those where the condition is met.

Cannot add or update a child row: a foreign key constraint fails MYSQL : EF Core #13328 New issue Closed as not planned ulhas07 ...