Relations created from database marked as error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
-marcelo-
Posts: 17
Joined: Wed 28 Jun 2017 12:35

Relations created from database marked as error

Post by -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: 17
Joined: Wed 28 Jun 2017 12:35

Re: Relations created from database marked as error

Post by -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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Relations created from database marked as error

Post by 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"

Post Reply