I am developing a credit card applicatoin with EF4.. Between your releases the database schema can alter (e.g. column added, table added...).

It is possible to method to commit these changes towards the clients database once they run the brand new release? I am considering an function much like CreateDatabase().

Your install procedure should do a couple of things:

  • Operate a script to update the database
  • Install the brand new program files

To create the database script make use of the tools in visual studio, see http://www.sqlskills.com/BLOGS/KIMBERLY/post/Data-Dude-moving-into-lower-priced-VS-Editions-in-VS-2010-excellent!.aspx