Foreign Key in MySql DB is determined incorrectly. Using a MUL column from the "describe
" query cannot uniquely identify a column as a foreign key because MUL there means "other than primary single or unique single key". So the generator fails, for example, on any unique multiple indices...
I modified the code a bit for my own purposes (see Attachment). I don't know how correct it is.
In MysqlMetadataReader.cs GetTableDetails function was modified.
Reader.zip
Foreign Key in MySql DB is determined incorrectly. Using a MUL column from the "describe
" query cannot uniquely identify a column as a foreign key because MUL there means "other than primary single or unique single key". So the generator fails, for example, on any unique multiple indices...I modified the code a bit for my own purposes (see Attachment). I don't know how correct it is.
In MysqlMetadataReader.cs GetTableDetails function was modified.
Reader.zip