Changing name of foreign key in Entity Designer

Changing name of foreign key in Entity Designer

Postby stephen.Cognito » Thu 29 Apr 2010 09:13


Using dotConnect PostgreSQL v2009 vol 3.4

We seem to have an issue when renaming a foreign key name within the new integrated VS Entity Designer. We have a table named TblTransactCrossRef
with 2 foreign keys named TblTransaction and TblTransaction1.
We can successfully rename TblTransaction to LinkedTransaction but when trying to rename TblTransaction1 to TblTransaction the model tells us this name is already in use. We have tried a number of ways to overcome this but to no result. We were able to successfully rename these FK in the previous versions of dotConnect.

Any ideas?
Many thanks


Stephen Wright
Cognito Software Limited
Posts: 10
Joined: Mon 18 Jan 2010 10:48
Location: Devon, UK

Postby AndreyR » Fri 30 Apr 2010 13:23

This issue seems to be associated with the referential constraint (Foreign Key) also present in the model in VS 2010 models.
Could you please send us (support * devart * com, subject "Duplicate FK Name") the model and the script of the tables taking part in the associations?
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for PostgreSQL