My recent database update failed in the middle of a migration, leaving the database inconsistent:
> dotnet ef database update
Applying migration '20200429031727_NewRequisitesAndCountry'.
Failed executing DbCommand (97ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
[...]
Microsoft.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not
permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Is there a way to wrap the migration in a transaction? I am interested in doing so both from the command line and programmatically while calling context.Database.Migrate()
.
User contributions licensed under CC BY-SA 3.0