asp.net mvc model database change

I've used mvcScaffolding and mvc3 to generate my tables in a sql2008 database. some data has been added.

I've开发者_StackOverflow changed a single model and wish to alter the underlying table.

1. is there a way to auto-update a single table to keep it in sync with the model?
2. after adding a new model how can the database table be created without recreating the database

---

You're looking for something like Rails' migrations. There are a couple .NET migrations providers floating around, but the basic setup you've described doesn't support alterations to the schema without recreating the database (at least in my experience).

---

have you tried treating your database an an existing one as described in this example by Scott Gu?

http://weblogs.asp.net/scottgu/archive/2010/08/03/using-ef-code-first-with-an-existing-database.aspx

Hopefully thias way you will not have to re-create your db everytime a change is required...

Regards

Paul