Code First Migrations - Upgrading to 7.0

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ndroe
Posts: 18
Joined: Fri 03 Feb 2012 16:08

Code First Migrations - Upgrading to 7.0

Post by ndroe » Thu 31 May 2012 12:23

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Code First Migrations - Upgrading to 7.0

Post by Shalex » Thu 31 May 2012 14:32

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Code First Migrations - Upgrading to 7.0

Post by Shalex » Thu 31 May 2012 16:02

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
Posts: 18
Joined: Fri 03 Feb 2012 16:08

Re: Code First Migrations - Upgrading to 7.0

Post by ndroe » Thu 31 May 2012 16:41

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Code First Migrations - Upgrading to 7.0

Post by Shalex » Fri 01 Jun 2012 16:38

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Code First Migrations - Upgrading to 7.0

Post by Shalex » Tue 05 Jun 2012 13:09

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Code First Migrations - Upgrading to 7.0

Post by Shalex » Fri 08 Jun 2012 15:54

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 .

Post Reply