DevForce Community Forum : Duplicate Table Names in Different Databases http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Duplicate Table Names in Different Databases Fri, 17 Apr 2026 11:47:43 -700 Thu, 12 Jul 2007 12:13:06 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=146 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Duplicate Table Names in Different Databases : Unfortunately, the solution was... http://www.ideablade.com/forum/forum_posts.asp?TID=146&PID=334#334 Author: Linguinut
Subject: 146
Posted: 12-Jul-2007 at 12:13pm

Unfortunately, the solution was only partial.  I had to manually change some naming in the oldPARTSMASTER.cs file.  The constructors section had labelled the partial class as PartsMaster.  That obviously conflicted with the real class' constructors.  Confusing, at best.  I hope it was just me doing something wrong.  After the Model build, it all looks OK; however, my next plan is to run the ORM again.  Crossing fingers.]]> Thu, 12 Jul 2007 12:13:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=146&PID=334#334 Duplicate Table Names in Different Databases : I have a PartsMaster table in... http://www.ideablade.com/forum/forum_posts.asp?TID=146&PID=313#313 Author: Linguinut
Subject: 146
Posted: 12-Jul-2007 at 11:27am

I have a PartsMaster table in database A, and a [PARTS MASTER] table in database B.  The A table has been in existence in my project for quite some time.  Today, I needed to access the older B table and incorporate it into my project.  I was going to call it oldPartsMaster; however, when I added the class, the name was automatically changed to PARTSMASTER (space was removed).  This is not good, because when I renamed the table to oldPartsMaster, it deleted the original PartsMaster.cs file.  Now, when I save the ORM and rebuild the Model project, it errors, stating that the PartsMaster.cs file is not found.  And, it really isn't there anymore.  I closed the object mapper and told it not to save the changes (too late!).  Even if I open it again and try to recreate the table, I get the same error.
 
Solution:  Delete from the ORM the PartsMaster class that is missing.  Add the oldPartsMaster class.  ReAdd the PartsMaster class.  Save.
 
The BIG problem now is recreating any custom code in the PartsMaster class that was lost:  Create method, Custom properties, etc.  I did not even think to record this elsewhere before making these changes.  Long ago, I removed VSS because it caused far more problems that it is worth.  My next option is to find a backup.  At least, I could copy/paste the customizations into the newly created class.
 
Has IdeaBlade considered this renaming thing and the potential damage to existing classes?  Any solutions on your part?  Perhaps I am doing something wrong in my approach.
 
Thanks!
Bill
]]> Thu, 12 Jul 2007 11:27:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=146&PID=313#313