Generate Database from NHibernate config files

Question

Is it possible to generate the database tables and c# classes from NHibernate config files? Afterwards, is it possible to change the config files and update the tables and config files non-destructively?

Do you recommend any tools to do this? (preferably free...)

Answer 1

As mentioned by Joachim, it's the "hbm2ddl.auto" setting that you're looking for.

You can set it by code like this:

var cfg = new NHibernate.Cfg.Configuration();
cfg.SetProperty("hbm2ddl.auto", "create");
cfg.Configure();

And you can also set it in your App.config file:

    <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
        <property name="hbm2ddl.auto">create</property>

Answer 2

check out the "hbm2ddl.auto" setting (in configuration or NHibernate.Cfg.Configuration ). with "create" you can recreate the whole database schema from your mappings and "update" setting should just update your schema.