It's usually not appropriate for your application to recreate database tables each time it runs. In this recipe, we'll generate a SQL script to create your database objects.
- Complete the Configuring NHibernate with App.config recipe at the beginning of this chapter.
- Install Microsoft SQL Server 2008 Express on your PC, using the default settings.
- Create a blank database named NHCookbook.
- Open
Program.cs. - Add the using statement:
using NHibernate.Tool.hbm2ddl;to the beginning of the file. - Add the following lines to the end of
Main.var schemaExport = new SchemaExport(nhConfig); schemaExport .SetOutputFile(@"db.sql") .Execute(false, false, false);
- Build and run your application.
- Inspect the newly created
db.sqlfile.
Using the mapping metadata from the configuration object and the current dialect, hbm2ddl builds a SQL script for your entities.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.