O'Reilly logo

NHibernate 3.0 Cookbook by Jason Dentler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Scripting the database

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.

Getting ready

  1. Complete the Configuring NHibernate with App.config recipe at the beginning of this chapter.
  2. Install Microsoft SQL Server 2008 Express on your PC, using the default settings.
  3. Create a blank database named NHCookbook.

    Note

    This recipe works for any RDBMS supported by NHibernate. To use a different system, adjust your connection string and dialect accordingly.

How to do it...

  1. Open Program.cs.
  2. Add the using statement: using NHibernate.Tool.hbm2ddl; to the beginning of the file.
  3. Add the following lines to the end of Main.
    var schemaExport = new SchemaExport(nhConfig); ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required