Google pattern Unit of Work
or here to begin with - Pattern Unit of Work
UoW is in EntityFramework, you can reuse it.
if you microcerinae of architecture, then Google pattern Saga
or here esteem - Pattern: Saga
in General, a letter about the change of role must send a separate micro service, and not the code that writes to the database.
event-based, so ideally, it is necessary to raise the bus (RabbitMQ) and link them asynchronously.