Execution strategy for migration

[ariellourenco]

Dear all,

I am wondering if the SQL execution strategy specified when configuring the options for the context also covers the Migrate command when it takes place as part of the chain of events of the IWebHost as in the code sample in this discussion

[AndriySvyryd]

No, there are commands that cannot be executed in a transaction and therefore cannot be safely retried.

[bricelam]

But we could retry the ones that are in a transaction and do something fancy with Down operations or idempotent DDL statements (IF NOT EXISTS) to recover from failures outside of a transaction.

[escalonn]

I'm just looking for a built-in way to retry the connection itself, not any of the operations within it.

[AndriySvyryd]

When retrying without a transaction we can start from the last command that succeeded.

[roji]

Reopening to track reviewing my comments on #34206 (accidentally approved with auto-merge on).