I'm currently trying to port EF6 code first project from MSSQL to MySql and ran into problem where I get this error message:
Foreign key name 'FK_ClientApplicationControlAccesses_ClientApplicationControls_ClientApplicationControlId' in table ClientApplicationControlAccesses is too long (88 characters). An identifier with more than 64 characters was specified.
I didn't need to search for a long to find posts about how oracle and postgresql connectors have built in fucntion to truncate too long foreign keys. I searched a little more and found similiar feature in MySql connector, but I fail to get it working.
I put following lines to app.config of the project:
Code: Select all
<configuration>
<Devart.Data.MySql.Entity>
<CodeFirstOptions TruncateLongDefaultNames="true" />
</Devart.Data.MySql.Entity>
</configuration>