Page 1 of 1
Relations created from database marked as error
Posted: Fri 01 Sep 2017 18:10
by -marcelo-
I generated my Entity model from a database.
Two of the relations are marked with the red circle.
But seeing them shows no difference with those analogous not marked.
What is going?
Any help will be welcome
Re: Relations created from database marked as error
Posted: Sat 02 Sep 2017 20:57
by -marcelo-
Solved: the reason behind the error was different types between the foreign key field and the reference´s primary one. This was an Int64 and the foreign was Int32.
The joke is the database was initially created from the model, which had (obviously) that field types. No warning, no error on database creation.
Nevertheless, Entity Developer is a good tool.
Re: Relations created from database marked as error
Posted: Thu 07 Sep 2017 04:44
by Shalex
The issue you described is possible if you set manually different values in the Server Data Type property of the fields which participate in the relation.
JIC: you can enable the following option to synchronize Server Data Type with Type automatically
Model Settings > Synchronization > Mapping > "Enable automatic synchronization of storage part and mapping of the model with its conceptual part"