Integration Testing Adding a database file to my test project. How can i do this

Question

I need to do integration testing. At the moment, I have several scripts that run once per assembly, which create db if they do not exist and populate it.

I thought it would be better if I could add the database to the test project and then just fill and clear the db accordingly. Even if this is not the best way. How to add a database file, for example "MyTestDB.mdf" to my project. I am using VS 2010 Premium Edition.

Suggestions?

Answer 1

, SQL Server ( ) , - .

" Fixture" , , . . , , .

, , .