No rollback support in devart oracle provider for code first migrations

[John Liu]

PM> Update-Database -verbose
Error occurred in the middle of the process. the database is partially updated. there is no rollback implemented. Can we have an option that every database update is an atomic action?

[Shalex]

Oracle server doesn't support a transactional DDL. As a possible solution in this situation, specify the –Verbose flag so that you can see the SQL that Code First Migrations is running (as you have specified in your example) - you will find which exact changes were applied before the fail. After this, you should write and execute the "rollback" statements manually.

We will investigate the possibility of implementing a mechanism for more convenient processing this problem.

[John Liu]

Thank you for willing to look into this problem further. If rollback can not be done, can you modify your sql generation to drop table/index by checking if they are still exist first? so we manually fix the database, and run Update-Datagbase again.
thanks
John