Changing name of foreign key in Entity Designer

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 10
Joined: Mon 18 Jan 2010 10:48
Location: Devon, UK

Changing name of foreign key in Entity Designer

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

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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

Post Reply