Thanks for the suggestion, it looks interesting. I'm kinda new to Castle Activerecord so I was thinking since it creates the schema, it would also have the ability to update the tables with new columns if I add new properties to the class or add new tables if I create a new derived type out of existing base type. I guess I'm wrong. It looks like you can only create the schema once. After that, if you modify your class or create a new derived type, then it is upto you to make that change in the database. Is this correct? The Castle website doesn't seem to have any info regarding these issues. I checked out the activerecord docs and couldn't find anything. Any help is greatly appriciated.
On Oct 16, 3:06 pm, "Jonathon Rossi" <[EMAIL PROTECTED]> wrote: > Maybe you are after something like MIgrator.NET available on google code. > > > > On Thu, Oct 16, 2008 at 11:59 PM, devmet <[EMAIL PROTECTED]> wrote: > > > I was looking for a more castle activerecord solution. Something like > > CreateSchema(), is there something that updates the database with the > > new table and creates the relationship of that new table with the base > > table? > > > On Oct 15, 8:52 pm, "Ken Egozi" <[EMAIL PROTECTED]> wrote: > > > what about > > > > CREATE TABLE Abc ( ...) > > > ? > > > > On Thu, Oct 16, 2008 at 3:32 AM, devmet <[EMAIL PROTECTED]> wrote: > > > > > Hi everybody, > > > > > I have an abstract class and two child concrete classes from that > > > > abstract class. I have implemented Class Table Inheritance for these. > > > > These tables are now in production and they already have production > > > > data in them. Now, there is a need for another concrete class from the > > > > same abstract class. Implementing the class is not a problem, it just > > > > follows the previous two. However, I don't know how to create table > > > > for this type and make it related to the base table already in the > > > > production. I don't see any "UpdateSchema" or anything like that in > > > > ActiveRecordStarter. There is only CreateSchema(). The following is > > > > what I tried and was unsuccessful. > > > > > I tried to just initialize the new type and to create schema for it > > > > but I received an error saying that it was missing the primary key. > > > > > I initialized the base type with it and tried to create the schema > > > > but it errored out saying that the table already existed. > > > > > Then I tried CreateSchems(typeof(NewType)), This seems to have created > > > > the table but I'm not sure if it created the relationship too because > > > > when I deleted the base table, it didn't give any error message. > > > > > Any help is greatly appriciated. > > > > > devmet > > > > -- > > > Ken Egozi. > >http://www.kenegozi.com/bloghttp://www.musicglue.comhttp://www.castle... > > -- > Jonathon Rossi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
