Add fake in memory connection provider

The fake provider won't close connection until we say so and thus
database won't be wiped from memory.
See:
http://notepad2.wordpress.com/2008/05/19/unit-testing-castle-active-record-using-sqlite-in-memory-database/