Unit Testing ActiveRecord Applications using Mock Databases

When unit testing a web apps built on Castle ActiveRecord, SQL Server database backing does not fit the needs of the test. Tests need fast, guaranteed, isolated data that can disappear when the test completes. Using SQLite and in-memory databases, you can have just that.