Page 1 of 1

Model.edmx update

Posted: Wed 17 Jun 2009 23:07
by danielliu8
Hi,

I have a project built with the "ADO.Net Entity Data model" and "dotConnect for Oracle", I craeted Model.edmx, and it working fine.

We added several new tables and relationship to Oracle 10g, is it anyway I could modify the Model.edmx to add these new tables?

I do not want to delete this Model.edmx and create another Model.edmx in my project, since our database schema is keep changing in developement stage.

Thanks

Posted: Thu 18 Jun 2009 07:08
by AndreyR
Open the model in designer, right-click on any node in the Model Browser and choose Update model from database option.
Select objects you wish to add, modify or delete.
Be aware of known problems and limitations of this wizard, for example, overwriting all manual storage model changes.

Posted: Thu 18 Jun 2009 17:08
by danielliu8
Thanks

Would you please list the details for the known problems and limitations of this wizard, for example, overwriting all manual storage model changes?

I do not want to mess up the Existing model by updating it.

thanks

Posted: Fri 19 Jun 2009 07:15
by AndreyR
Some information can be found in ADO.NET Team blog in the following entry:
http://blogs.msdn.com/adonet/archive/20 ... om-db.aspx