I know it's possible to run extra DDL scripts with NHibernate. For example triggers or indexes. This feature is NHibernate is named "Auxiliary Database Objects".
Is it possible to do same thing in Castle ActiveRecord?
A:
ActiveRecordStarter.CreateSchemaFromFile("myscript1.sql");
(from http://www.castleproject.org/activerecord/documentation/trunk/usersguide/schemagen.html)
Diego Mijelshon
2010-10-10 12:58:41
@Diego, I'm currently generating database schema based on classes. "myscript1.sql" must be run as complementary. It seems to me that `CreateSchemaFromFile` prevents tables to be created from classes.
afsharm
2010-10-10 13:08:42
@afsharm: I'm pretty sure you can run both.
Mauricio Scheffer
2010-10-10 13:51:22
Did you read the doc I've just linked to?
Diego Mijelshon
2010-10-10 15:11:06
@Diego, It does not work. calling `CreateSchemaFromFile` does not do any operation.
afsharm
2010-10-11 06:49:44
A:
Just like Diego said, ActiveRecordStarter.CreateSchemaFromFile is the way to do this.
If it doesn't execute anything, make sure your SQL script has its lines separated by ; (or GO). Even if you have a single line in your file, it has to end with ;
Mauricio Scheffer
2010-10-14 16:08:05
@Mauricio: I added ; and go at end of lines and end of scripts files. But still nothing works. I used SQL Profiler but nothing is sent to database.
afsharm
2010-10-16 06:22:16