UnitTesting with SQLite

I just had one of those frustrating moments where the unit tests on my machine works but those on the build server does not! This time I was pretty sure what the issue was. Any time that StructureMap tries to build the session factory and this fails I get strange exceptions in places that hasn’t even been hit. This caused me to first ponder why it would not configure NHibernate on the build server and instantly I thought of SQLite. Now don’t get me wrong I love SQLite but the difference between the x64 and the x86 version has caused me a lot of problems.

I ended up checking if the build number property is set in the build script and if so copy the x86 version of System.Data.SQLite.dll and overwrite the x64 one I use by default. I wouldn’t say that is convention over configuration… I’d say it’s a kick in the nuts for convention this time but it’ll have to do.