How should ExecuteUpdate and ExecuteDelete be designed for production in Entity Framework Core?

Use set-based operations for suitable rules, validate filters carefully, and consider auditing and transaction boundaries.