Import the AdventureWorks Entity Schema

In this task, you will learn to import MetaData from the Database to Entity Designer.

EntityDesigner helps you define a conceptual model for the application.

  Add a new Connection to AdventureWorks Database

  1. Open the Server Explorer Window: on Menu View, select Server Explorer.

  2. Select Data Connection, right click Add Connection...

  3. Choose your Database Server, and the AdventureWorks DataBase
  4. Click OK to create the Connection

 


  Add a new Schema to your Application
  1. In Solution Explorer, right click AspectizeDALdemo Solution, and choose Add New Item...
  2. Choose the Aspectize Entity Designer Template. 

  3. Name the Schema, AdventureWorks.Production.Entities

  4. Click OK to create the file.


  To import Entities from the DataBase

  1. In the Server Explorer Window, expand Data Connection Node, and the corresponding Node of your AdventureWorks Connection.

  2. Expand the Node Tables.

  3. Select Tables to be imported: press Ctrl Key to select multiple Tables.
  4. Select Tables: Productcategory, ProductSubCategory, Product
  5. Drop the selected Tables in the Schema Surface
  6. The Entities and Relations are created
  7. Rearrange Entities and Relations by moving shapes

Next Step: Implementing the Query Scenario

Back to QuickStart Home Page