Page 1 of 1

Best way to update a table

Posted: Fri 22 Jan 2010 11:33
by Fortis
What is the suggested/encouraged way to update a changed table (ie a table that has 10 new columns/changed column names)?
This happens quite frequently to me and at the moment I dont have a solution that is not painfully cumbersome...
(and I know schemaupdates from the database is a planned feature, but in the meantime...)

Posted: Fri 22 Jan 2010 14:11
by AndreyR
At the moment I recommend you to drop the table on the designer (if you are using Entity Framework,
don't forget the Store part of the model) and add it again.
One more solution is to manually update the model in design time, but it is also time-consuming.

Posted: Fri 22 Jan 2010 14:38
by Fortis
:cry:
Dropping the table is not really a good option, since you have to redo all work you did on the set (like renaming entities/association and everything else). That process is also errorprone (since we are humans).

Any ETA on the updatefeature? I would even settle with an "Only add new columns not in the current storagemodel" :-)