title: Problem using SQLite :memory: with NHibernate
body: <p>I use NHibernate for my dataacess, and for awhile not I've been using SQLite for local integration tests.  I've been using a file, but I thought I would out the :memory: option.  When I fire up any of the integration tests, the database seems to be created (NHibernate spits out the table creation sql) but interfacting with the database causes an error.</p>
  
  <p>Has anyone every gotten NHibernate working with an in memory database?  Is it even possible?  The connection string I'm using is this:</p>
  
  <pre><code>Data Source=:memory:;Version=3;New=True
  </code></pre>