indomitablehef.com » NHibernate

Home

About

in·dom·i·ta·ble
adj. Incapable of being overcome, subdued, or vanquished; unconquerable.

29th
JAN

Schema Generation using FluentNHibernate and S#arp Architecture

Posted by indomitablehef | Filed under S#arp Architecture, NHibernate

This took me several hours to figure out, and even though it makes me look bad to admit that, I figured I’d share what I eventually came up with.

I’ve been using S#arp Architecture for ASP.Net MVC, which uses FluentNHibernate. The S#arp Architecture project template generates the following test, used to test the FluentNHibernate mappings:

    [TestFixture]
    [Category("DB Tests")]
    public class MappingIntegrationTests
    {
        [SetUp]
        public virtual void SetUp()
        {
            string[] mappingAssemblies = RepositoryTestsHelper.GetMappingAssemblies();
            NHibernateSession.Init(new SimpleSessionStorage(), mappingAssemblies,
                "../../../../app/FuBar1.Web/Hibernate.cfg.xml");
        }
<...>

To do the Schema Export based on the FluentNHibernate mappings, you need to get at the NHibernate Configuration object.
Luckily, the NHibernateSession.Init method returns the Configuration object. So, I modified the Setup for the MappingIntegrationTests class to:

    [TestFixture]
    [Category("DB Tests")]
    public class MappingIntegrationTests
    {
        private Configuration cfg;
 
        [SetUp]
        public virtual void SetUp()
        {
            string[] mappingAssemblies = RepositoryTestsHelper.GetMappingAssemblies();
            cfg = NHibernateSession.Init(new SimpleSessionStorage(), mappingAssemblies,
                "../../../../app/FuBar1.Web/Hibernate.cfg.xml");
        }
<...>

…capturing the Configuration in a private variable.

I then added this [Test] method to the class, to do the SchemaExport:

        [Test]
        public void SchemaGeneration()
        {
            var session = NHibernateSession.SessionFactory.OpenSession();
            new SchemaExport(cfg).Execute(true, false, false, false, session.Connection, null);
            Assert.IsTrue(true);
        }