Mysql deployment script generated in EF Core 5.0 doesn't support DDL transaction rollback

RafeeqAbd 1 Reputation point
2021-10-21T18:37:21.937+00:00

We are using EF core 5.0 with pomelo mysql db provider. We generate an idempotent sql script to add migration using efcore migration commands. We noticed that the transactions are not rolled back if there are db connection or timeout errors.

How can we ensure the generated script is idempotent, since in the existing state it doesn't behave right.

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
696 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
{count} votes