Usually, EF core migration will be wrapped in a single transaction automatically.
I have a migration which will create two new tables.
When I try to use it to update the database, the creation of the second table failed.
So the migration is not executed successfully, but the first table is created in the database.
Could you please advise this?
BTW, I am using this as the ORM NuGet Gallery | Pomelo.EntityFrameworkCore.MySql 7.0.0
DDL statements (including CREATE TABLE) should be run in a transaction by themselves. A DDL statement commits any currently active multi-statement transaction. If it is possible to change your ORM configuration to run every transaction in a single statement, at least during the phase where you are getting an error, try that.