The create schema methods available in ActiveRecord just calls the hbm2ddl tool in NHibernate to generate DDL scripts to create everything. You are correct in saying that it doesn't allow you keep updating your database schema because it would have to deal with your schema changing with data in the tables.
I doubt many people actually use those methods to build their real databases; I expect they are more for prototyping. I would assume most people would create SQL upgrade scripts manually or use something like Migrator.NET to do the same from C#. On Fri, Oct 17, 2008 at 12:02 PM, devmet <[EMAIL PROTECTED]> wrote: > > 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 > > > -- 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 -~----------~----~----~----~------~----~------~--~---
