title: In-memory DBMS's for unit testing
body: <p>I am looking for satisfactory options for unit testing my .NET DAL classes; since they're DAL classes, they access the database directly using ADO.NET.  Presently I use an instance of a MSSQL database for the testing, but was wondering what faster options there are---since unit tests need to run as quickly as possible, an in-memory solution would be ideal.</p>
  
  <p>I should also mention that I have tied myself to TSQL since I'm only ever going to be using a Microsoft platform.</p>