I have a problem when generating a model from a DB that has a table with a FK to a table in another schema. Entity Developer doesn't seem to acknowledge that the FK exists and no association between both entities is created.
If I create the association manually and then try to update the DB from the Model it says a FK needs to be created.
You can reproduce it following these steps:
1. Create two databases in mysql. Call them "SchA" an "SchB"
2. Run the following SQL Script to create 3 tables and some FKs
Code: Select all
create table SchB.TableB(id int primary key);
create table SchA.TableC(id int primary key);
create table SchA.TableA(
id int primary key,
id_B int,
id_C int,
FOREIGN KEY FK_TEST_B(id_B) REFERENCES SchB.TableB(id),
FOREIGN KEY FK_TEST_C(id_C) REFERENCES SchA.TableC(id));
4. The result will be something like this
As you can see no association between TableA and TableB has been created, but the association between TableA and TableC has been correctly added.
I've tested this with Entity Developer Pro 6.2.439 and MySql 5.6.25
Thanks!