Code First Migrations - Upgrading to 7.0

[ndroe]

It appears that the index name behavior has changed when upgrading from 6.80 to 7.0. In the 6.80 version, index names were never quoted when added to the database. It appears that they are in 7.0. This makes migrations that run fine in 6.80 error in 7.0.

I didn't see anything about this in the release notes. Is this expected behavior?

Thanks,
Nathan

[Shalex]

Thank you for the remark. The behaviour change is the bug fix which was not mentioned in the release notes. We have to quote all identificators (including indexes) in a standard mode.

[Shalex]

You should edit your old code-based migrations (make old indexes names in UPPERCASE) for compatibility with the migrations which have been already applied to Oracle databases.

[ndroe]

We can't really do that for old code-based migrations that have already been executed against a database without throwing the database away and starting from scratch. It's not ok for me to ask all my developers to take the time to start their database over losing all the data that they've entered into it. Is there any other workaround for this?

[Shalex]

In the next public build we will implement the configuration option which will allow to set the mode of generating indexes without quotes for compatibility with Code-First Migrations that are generated and applied with the 6.x providers versions (enabling this option is not recommended for the newly created projects!). We will post here when the corresponding build of dotConnect for Oracle is available for download.

[Shalex]

The config.Workarounds.DisableIndexQuoting option is implemented for a backward compatibility with migrations which use indexes, generated and applied in the 6.xx versions. We will post here when the corresponding build of dotConnect for Oracle is available for download.

[Shalex]

New build of dotConnect for Oracle 7.0.17 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=24290 .