The Select Changes page provides you with details about the Added, Refreshed, Deleted objects, and about the changes that the Update from Database wizard makes to the current domain model.
The grid located at the center of the screen, shows the database item (the From database column), the corresponding domain model item (the To model column) and the operation, which the Update from Database wizard will perform to update the domain model (the Operation column).
The Update from Database wizard does the following:
- If tables/views have been deleted from the database, the wizard won't delete the corresponding entities from the domain model. In this case, you have to remove the entities manually.
- If an object has been added to the database (or was not included in the previous domain model), you can choose to add the object to the model. The relational model is updated with the newly-added object. In case of a table or view (but not a stored procedure), a corresponding persistent type is created and mapped to the object.
- If an object has been updated, the wizard updates the object definition in the relational model. If any new columns have been added to a table or view, the corresponding persistent types are updated with matching properties. If the corresponding persistent types are part of an inheritance hierarchy, only the affected type which is closest to the root of the hierarchy is updated with matching properties. This prevents child types in the hierarchy from defining the same properties as their ancestors.