Relations created from database marked as error

Relations created from database marked as error

Postby -marcelo- » Fri 01 Sep 2017 18:10

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
-marcelo-
 
Posts: 14
Joined: Wed 28 Jun 2017 12:35

Re: Relations created from database marked as error

Postby -marcelo- » Sat 02 Sep 2017 20:57

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.
-marcelo-
 
Posts: 14
Joined: Wed 28 Jun 2017 12:35

Re: Relations created from database marked as error

Postby Shalex » Thu 07 Sep 2017 04:44

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"
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL