How Do I Attach a SQL Server Express Database to a Visual Studio 2010 project?

How do I do this?

• Attach an SQL Server Express Database to a Visual Studio project so that...
  • my source control contains the most resent schema for the database including stored proced开发者_开发问答ures (can' t use SQL Compact Ed. because need to be able write stored procedures against the database),
  • can be version controlled using TFS without using tools like Red Gate Source Control,
  • can be automatically set up/updated when a developer gets the latest version of a project (using MS Build or similar build script api),
  • (would be nice) can be published after entire project passes unit tests.

Is any of this possible and if so how do I do it?

---

Sounds like you want a migration framework, more than you want to store the actual database. Look into migration libraries for .Net like FluentMigrator.

---

This sounds like continuous Database Integration:

http://www.codeproject.com/KB/architecture/Database_CI.aspx