Print Page | Close Window

changing the names of the tables

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=533
Printed Date: 29-Aug-2025 at 8:32am


Topic: changing the names of the tables
Posted By: Dominique
Subject: changing the names of the tables
Date Posted: 02-Nov-2007 at 7:14am
Hi,
I will need to change the names of the tables in the db (ex from User to aa_User)and I can't find directives for how I could update the mapping to reflect these changes. Could you give me a pointer to ressource explaining how to do that?
thanks :-)
Dominique

-------------
Dominique


Replies:
Posted By: Linguinut
Date Posted: 02-Nov-2007 at 9:30am
Here is where the ORM is a real gem! 
 
The key idea is to keep your class name the same. 
 
After the name of the table is changed in the DB, open the ORM mapper and allow it to update the objects/schema (first option).  You'll be notified that there is a change.  Jot down the class name that will have a new database table name (e.g. "User").  Remove the offending class.  This may not feel like the right thing to do, but at this point no changes have been made yet to your model project.  All is well.  Next, add the new table from the datasource.  Rename the class which will default to the new table name (e.g. "aa_User") to the original class name (e.g. "User").  Save the mapper's changes and the model project will be updated with the database table name change. 
 
The best thing is that ALL of your code that references that business class will be unaffected.  Only you and the DBA will have to know that anything even happened.
 
Hope that helps,
Bill

Posted By: Dominique
Date Posted: 04-Nov-2007 at 11:44pm
Hi Bill,
Thank you for your reply. I guess I will do it that way :-)

It would be nice to have the possibility to rename the table from inside the mapper which could take care of all the relations. I guess it is possible to do that right into the ".orm" file.
But my new chrismas wish would be a rename function with the following use case :-)
1> open mapper
2> Choose "Do not validate mapping, allow all edits
3> Choose "rename tables" (maybe with a possibility to choose from the db schema)
4> Mapper has updated the mapping inclusive the defined relations :-)

Dominique

-------------
Dominique

Posted By: Linguinut
Date Posted: 06-Nov-2007 at 9:07am
You know, it would be rather nice to be able to just change the name of the source table within the utility.  A little remapper popup to make the job easier...just point the class to the renamed table and all would be well.  I think the reasoning that this doesn't exist in DevForce is that database table naming rarely changes once created, so the feature would receive a low priority rating.


Print Page | Close Window