Generating Database Schema Script from NHibernate

Question

I have inherited a .NET 2008 MVC application that uses nhibernate. The previous developer didn't get as far as generating a database for this project. I am fairly new to nhibernate, and I am trying to figure out what would be the optimal solution for creating a database script for creating a new database using the current mappings. I have gone through many posts on this site, but still do not understand completely how to get this to work. Any guidance is appreciated.

Thank you!

Bredstik · Accepted Answer · 2013-06-20 20:01:56Z

7

Assuming you have hbm.xml mappings and a valid nhibernate config file, you could write the following code in a console app to generate the SQL schema:

//load initial config from hibernate config file
Configuration cfg = new Configuration().Configure("hibernate.cfg.xml");

//add assembly in which the hbm.xml mappings are embedded (assuming Product class is in this assembly)
cfg.AddAssembly(typeof(Product).Assembly);

//this will generate the SQL schema file in the executable folder
new SchemaExport(cfg).SetOutputFile("schema.sql").Execute(true, false, false);

If you have fluent mappings, it should look more like this:

Fluently.Configure().Database(MsSqlConfiguration.MsSql2005).Mappings(
            m => m.FluentMappings.AddFromAssemblyOf<Product>()).ExposeConfiguration(
                config =>
                    {
                        new SchemaExport(config).SetOutputFile("schema.sql").Execute(true, false, false);
                    }).BuildConfiguration();

answered Jun 20, 2013 at 20:01

Bredstik

6465 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

ssokol91 Over a year ago

Thanks! I have fluent mappings. When you are saying write a code in a console app, how to I attach that console to my solution? Thanks again for this!

Bredstik Over a year ago

Basically, add a new "Console Application" project to your existing visual studio solution. Or you could add this bunch of code at the startup of your existing app or in an event, wherever you like.

ssokol91 Over a year ago

That's great! I have noticed the line "AddFromAssemblyOf<Product>". Do I have to do this for every mapped class, or am I not understanding it properly? Tks!

Bredstik Over a year ago

Assuming all you fluent mappings are in the same assembly, you only have to specify one of the class inside that assembly. It will automatically scan for all mappings inside that assembly based on the type your provide.

ssokol91 Over a year ago

I have added the code right after nhibernate session gets initialize. The code runs fine, but the schema.sql is coming up blank. Any ideas? Tks!

Collectives™ on Stack Overflow

Generating Database Schema Script from NHibernate

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related