Database Modeling
Design, generate, reverse and synchronize database with sophisticated ERD. Generate professional documentation.
Entity relationship diagram
Entity relationship diagram (ERD) is used to present the Entity-Relationship Model in software engineering industry. ERD can be used for visualizing conceptual data structure and physical database schema. Smart Development Environment for Visual Studio supports conceptual, logical and physical data modeling.
The following movie shows how to create conceptual data model and transit the conceptual data model to physical. The movie shows also the modeling of physical database schema, stored procedure and generates DDL from physical database design.
Synchronization between ERD and class diagram
Entity relationship diagrams (ERD) presents persistent structure of the database, and class diagrams presents object structure in memory. There is alignment between ERD and class diagram. For example the column in entity can map to attribute in class. Smart Development Environment for Visual Studio supports generating class diagram from ERD and synchronize changes from ERD to class diagram, and vice versa.
Object-Relational Mapping diagram
Object-relational mapping diagram (ORM diagram) presents the mapping between classes and entities visually. Visualization between classes and entities can help developer to gain more understanding of how a row of data in database transform to/from object in memory. The following movie shows how to visualize the mapping between classes and entities.
Stored procedure and trigger
Smart Development Environment for Visual Studio can design, reverse and generate stored procedures and database triggers. Flexible grouping helps to group stored procedures and triggers in meaningful way.