Using Linq to SQL and dbml to create _and_ upgrade database?

Im using dbml (c# vs2010) to model my database and DataContext.CreateDatabase() to create it. Some time later I add a new property to one entity-type and now I want to upgrade the SQL-database to fit the new version of the dbml-schema. How do I accomplish this? Do I have to delete and re-create the database or u开发者_如何学Pythonpgrade it manually? Is ADO.NET EF better in this respect?

Update:

When searching for methods of updating the database according to changes in dbml I only get results for the inverse; updating dbml from changes in the database. But what is then the visual designer in dbml for? I want some master-design-view where I can do my changes and then generate sql-upgrade-script from that. Isnt that what everyone wants?

Neither Linq2Sql nor EF are made for this kind of scenario.

You asked if this is possible so in response to that I'll say that in theory I guess you could hack around this in EF by altering the schema of your db and using some script to alter the DBML file but I would highly recommend against it. Use the right tool for the job.

Sounds like ADO.NET might be a better solution for you.