Sure, an example using loquacious configuration:
Configuration cfg = this.CreateConfiguration()
.DataBaseIntegration(db =>
{
db.ConnectionStringName = "connectionStringName";
db.Dialect<MsSql2008Dialect>();
db.Driver<Sql2008ClientDriver>();
db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'";
db.KeywordsAutoImport = Hbm2DDLKeyWords.AutoQuote;
db.SchemaAction = SchemaAutoAction.Validate;
})
The key is the SchemaAutoAction.Validate, it will check if any table is
missing or does not have the required columns, in which case an exception
will be thrown when the session factory is built. The other useful value is
Update, which will create them.
RP
On Monday, May 20, 2013 7:12:20 AM UTC+1, Sean Farrow wrote:
>
> Hi,
>
>
>
> I’m working on a project where I need to test whether a schema is
> up-to-date or has even been created.
>
> I’m currently looking at the number of tables in the database and checking
> whether it is equal to the number of map files in the project.
>
> Is there a more reliable way using NHibernate only?
>
> Help appreciated.
>
> Cheers
>
> Sean.
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
