DevForce Community Forum : changing the names of the tables http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : changing the names of the tables Wed, 15 Apr 2026 09:23:05 -700 Tue, 06 Nov 2007 09:07:39 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=533 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ changing the names of the tables : You know, it would be rather nice... http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1880#1880 Author: Linguinut
Subject: 533
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.]]> Tue, 06 Nov 2007 09:07:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1880#1880 changing the names of the tables : Hi Bill, Thank you for your reply.... http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1876#1876 Author: Dominique
Subject: 533
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

Edited by Dominique - 04-Nov-2007 at 11:44pm]]> Sun, 04 Nov 2007 23:44:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1876#1876 changing the names of the tables : Here is where the ORM is a real... http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1863#1863 Author: Linguinut
Subject: 533
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
]]> Fri, 02 Nov 2007 09:30:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1863#1863 changing the names of the tables : Hi, I will need to change the... http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1859#1859 Author: Dominique
Subject: 533
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]]> Fri, 02 Nov 2007 07:14:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=533&PID=1859#1859