Data Modeling

Consistent DB Column Type

Centralize the definition of a column type. Use it in class attributes and let code generation take care of the translation. Any changes become a breeze!

Input sample data or initial database data when design database with Entity Relationship Diagram (ERD). The generated database initialization script includes insert sample data to the database.

Mapping View:

	Class Mapping

	Attribute Mapping

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.

Know-how

• Comparison of query performance when working with ORM

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.

Preview for potential problems in the Data Definition Language (DDL) or Data Manipulation Language (DML) statements for selected entities ad-hoc.

Smart Development Environment for Visual Studio imports AllFusion ERWin Data Modeler project files. You can import your entire AllFusion ERWin Data Modeler project files into Visual Paradigm format. The following screenshots demonstrate how to import AllFusion ERWin Data Modeler project file.

Import ERWin Data Modeler project files

Step 1 of 3: Produce XML file from ERwin

In ERwin Data Model, save the project as an XML file.

Step 2 of 3: To import ERwin project

Import the XML file in VP by selecting File > Import > ERwin Project (XML)... from the main menu.

Step 3 of 3: Specify file path

Specify the file path of the XML file, then click OK. After that, select the imported diagram(s) to open. Once complete, you may perform modeling in VP in further.