Devart Forums

Under the right conditions, the migrations are generating foreign key and index names that are longer than the 30 character maximum for Oracle. I assume this would be the same for table names, column names, etc. too.

Is there any way to handle this in the provider? Could the names be truncated somehow? At a minimum, it would be nice to get an error before executing the migration and getting part way through a schema change that cannot be easily rolled back.

Thank you for your suggestions. We are investigating the possibility to check the length of the names and to implement the renaming (if necessary). We will post here about the results.

We have published our article about Code-First Migrations support for Oracle, MySQL, PostgreSQL and SQLite at http://www.devart.com/blogs/dotconnect/ ... qlite.html.

The validation of identifier name length in Code-First Migrations is implemented. We will post here when the corresponding build of dotConnect for Oracle is available for download.

New build of dotConnect for Oracle 6.70.311 is available for download now!
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://www.devart.com/forums/viewtopic.php?t=23469 .

I'm getting the following error:

System.InvalidOperationException: Foreign key name '"FK_Audits_Operators_OperatorId"' in table '"Audits"' is too long. An identifier with more than 30 characters was specified.

Notice that the text between the double quotes is exactly 30 characters long. It looks like the double quotes are being counted in the calculation of the maximum length.

Thank you for your report. We will investigate the issue and notify you about the results.

The bug with validation of identifier name length in Code-First Migrations is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.

New version of dotConnect for Oracle 6.80 is released!
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://www.devart.com/forums/viewtopic.php?t=23639 .

The config.CodeFirstOptions.TruncateLongDefaultNames configuration option is added (default value is False) to provide the possibility of truncating long default names of indexes, primary keys, foreign keys, triggers, and sequences generated by Code-First Migrations.
We will post here when the corresponding build of dotConnect for Oracle is available for download.

New version of dotConnect for Oracle 7.1 is released!
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=24522 .