Devart Forums

Please i have a problem: i have oracle database with a small set of tables and foreign keys between each other, when i generate the model from the database using entity framework designer most of this foreign keys didn't mapped but when i use EntityDeveloper every thing is OK, Can you help me to know why this was happen

Any help please

Sorry for the delay.

Could you please specify or send us the definitions of the tables used? We couldn't reproduce the problem with our test databases.

Also, please specify the versions of dotConnect for Oracle and Oracle server you are using.

I send all info as you want to support team

Oracle 11 g
windows server 2008
DotConnect 5.70

Thank you for the script, we've reproduced the issue. We will investigate the situation and inform you about the results.

Thanks, i wait you

I've deleted the duplicate topic in the Entity Developer forum.

OK thanks, but pleas i wait your answer

Is there are any answers ?

Is there are any answers ?

Is there are any answers ?

We are investigating the issue, we will inform you about the results as soon as possible. As a temporary workaround, you can add the missing associations manually.

Thank you for your assistance, there were two issues with generating the model:

1) The foreign keys missed in the EDM wizard. The problem is that the EDM wizard behaviour depends on the order in which foreign keys are retrieved. This can cause such issues in the case when a table has multiple associations. We've fixed the issue, the fix will be available in the nearest build.

2) Incorrect associations in Entity Developer. This issue is caused by incorrectly formed primary key (e.g., for the L_FDOC table). We will inform you when this problem is fixed.