title: In-memory SQLite and database disappearing
body: <p>I am using Nancy to create an api to a database, and am wanting to test / develop against an in-memory database.</p>
  
  <p>I am using an instance of my database class in a custom bootstrapper class with the connection string <code>Data Source=:memory:</code>, which in turn is creating the necessary tables - I have stepped through this and I'm confident this is occuring.</p>
  
  <p>I am then obtaining a new connection using the same connection string to load/save data, but even a simple select is coming up with the sql error that the table doesn't exist.</p>
  
  <p>Is there a fault in this logic of creating and using a new connection with the same connection string?</p>