Model.edmx update

danielliu8 · Post by **danielliu8** » Wed 17 Jun 2009 23:07

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

AndreyR · Post by **AndreyR** » Thu 18 Jun 2009 07:08

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.

danielliu8 · Post by **danielliu8** » Thu 18 Jun 2009 17:08

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

AndreyR · Post by **AndreyR** » Fri 19 Jun 2009 07:15

Some information can be found in ADO.NET Team blog in the following entry:
http://blogs.msdn.com/adonet/archive/20 ... om-db.aspx