This is a migrated thread and some comments may be shown as answers.

Effects of renaming primary keys and foreign keys in database

1 Answer 71 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Spiderman
Top achievements
Rank 1
Spiderman asked on 07 Jun 2012, 07:40 AM
Our firm is using telerik tools and open access. We hesitate to  rename primary keys and foreign keys in a database.
Does renaming  primary keys and foreign keys in a database, have bad effects  Open access Rlinq, i mean, does it disturb Rlinq.

Because , if it has bad effects, it is an expensive cost for us while updating our database.

By the way, we are your customer, how do i make my account related with my firm officially.I want to write here on behalf of my firm .

1 Answer, 1 is accepted

Sort by
0
Zoran
Telerik team
answered on 11 Jun 2012, 02:06 PM
Hi Spiderman,

 I am not sure I completely understood your scenario. Can you please clarify a bit, are you occasionally renaming your columns in the database? If you do so, the you should always use the Update From Database Wizard to propagate the changes to the .rlinq file. If you just rename your tables/columns in the database, you will have problems during runtime if you do not propagate those changes to the .rlinq model so OpenAccess is aware of the metadata of your relational database schema.

We will get back to you with additional details regarding your account questions and the support procedures. 

Greetings,
Zoran
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Tags
Databases and Data Types
Asked by
Spiderman
Top achievements
Rank 1
Answers by
Zoran
Telerik team
Share this question
or