Design and generate database

You can design database with ERD, and construct database by generating from the resulting ERD. In this tutorial, you will draw a simple ERD of phone book and generate database to MS SQL from it.

November 22, 2010
User Rating: / 2
Views: 1,913
PDF Link Link:	Add comments
Edition: Standard or above (Edition comparison)

Select New > Project... from the main menu of Visual Studio.
In the New Project dialog box, select Class Library as template, enter PhoneBook as project name and click OK.
In the Solution Explorer, right click on the project PhoneBook and select Open VP-UML from the popup menu.
Click OK when the project structure dialog box appears.
From the Diagram Navigator, right click on Entity Relationship Diagram node and select New Entity Relationship Diagram from the popup menu. This creates a blank entity relationship diagram.
Select Entity from the diagram toolbar.
Click on the diagram to create an entity. Name it as Book and press Enter to confirm editing.
Right click on the Book entity and select New Column from the popup menu.
Input +id : int and press Enter.
Input description : varchar(255) and press Enter. Press Esc to confirm editing.
A phone book contains many contacts. Let's create a Contact entity from the Book entity with a one-to-many-relationship. Move the mouse pointer over the Book entity. Press on One-to-Many Relationship -> Entity and drag it out.
Release the mouse button and name it as Contact.
Right click on the Contact entity and select New Column from the popup menu.
Input +id : int and press Enter.
Input name : varchar(100) and press Enter.
Input age : int and press Enter. Press Esc to confirm editing.
Select Modeling > ORM > Generate Database... from the main menu.
In the Database Code Generation dialog box, click Database Options.
In this tutorial, we use MS SQL Server as the target database. You may use your own database like My SQL, Oracle or other. Select MS SQL Server and fill in the setting on the right hand side. You may download the driver file by pressing the down button.
Click OK.
Check Export to database.
Click OK to start database generation.
Check the target database. You can see the tables generated.

Design and generate database

Rate this Article

You may be interested in

Comments (0)