Effects of renaming primary keys and foreign keys in database

2 posts, 0 answers
  1. Spiderman
    Spiderman avatar
    1 posts
    Member since:
    Feb 2012

    Posted 07 Jun 2012 Link to this post

    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 .
  2. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 11 Jun 2012 Link to this post

    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!
  3. DevCraft banner
Back to Top