Fast testing with the SQLite in-memory database

Running a full range of tests for a large NHibernate application can take some time. In this recipe, we will show you how to use SQLite's in-memory database to speed up this process.

Note

This is not meant to replace running integration tests against the real RDBMS before moving to production. Rather, it is a smoke test to provide feedback to developers quickly before running the slower integration tests.

Getting ready

Download and install NUnit from http://nunit.org.

Note

This recipe will work with other test frameworks such as MSTest, MbUnit, and xUnit. Just replace the NUnit-specific attributes with those for your preferred framework.

How to do it...

1. Create a new empty class library project.

2. Add references to our Eg.Core model from Chapter 2, Models and Mapping

3. Install the NUnit package using the NuGet Package Manager Console by executing the following command:

   Install-Package NUnit
   

4. Install SQLite using the NuGet Package Manager Console by executing...