OpenAccess provides you with a tool (Visual Designer) that separates the conceptual model from the relational model. In the Visual Designer you see/add/edit/delete the entities of the conceptual model while the actual tables to which the classes are mapped can be reviewed in the Model Schema Explorer.
In order to permanently remove a table from the domain model, you have to delete its class from the diagram displayed in the Visual Designer
and the table itself from the schema shown in the Model Schema Explorer
(You can start the Model Schema Explorer from View > Other Windows > Model Schema Explorer
). There you have to expand the Tables
tree, find the table you want to remove, right-click on it and select Remove table
. OpenAccess will warn you that you are about to remove the constraints linked to the table too and if you click Yes
, the table will be deleted.
In case you have accidently deleted the class from the diagram and you want it back, all you have to do is find the table in the Model Schema Explorer and drag-and-drop it in the Visual Designer (you do not need to update from the database).
The table will show in the Select Changes dialogue of the Update From Database wizard only if it was permanently removed / never added prior to the update.
Do not hesitate to get back to us if you have any other questions.
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!