Entity framework with mysql database migrations fail, when creating indexes

entity-framework-6 mysql mysql-connector

Question

What causes this MySQL entity framework error? Although I can write the migration script and establish a connection to the database, it dislikes the resulting SQL, especially when attempting to add indexes.

Example:

CREATE index  `IX_Facility_ID` on `Contact.Address` (`Facility_ID` DESC) using HASH

Error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect usage of spatial/fulltext/hash index and explicit index order

Is there a solution to this? This is using the most recent MySQL dlls and EF 6.

1
4
4/26/2018 5:29:42 PM

Popular Answer

ZZZ_tmp
6
8/8/2018 9:50:28 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow