title: Unit-Testing: Database set-up for tests
body: <p>I'm writing unit-tests for an app that uses a database, and I'd like to be able to run the app against some sample/test data - but I'm not sure of the best way to setup the initial test data for the tests.</p>
  
  <p>What I'm looking for is a means to run the code-under-test against the same database (or schematically identical) that I currently use while debugging - and before each test, I'd like to ensure that the database is reset to a clean slate prior to inserting the test data.</p>
  
  <p>I realize that using an IRepository pattern would allow me to remove the complexity of testing against an actual database, but I'm not sure that will be possible in my case.</p>
  
  <p>Any suggestions or articles that could point me in the right direction?</p>
  
  <p>Thanks!</p>
  
  <p>--EDIT--</p>
  
  <p>Thanks everyone, those are some great suggestions!  I'll probably go the route of mocking my data access layer, combined with some simple set-up classes to generate exactly the data I need per test.</p>