8.3.4.Creating EDM in Visual Studio 2008

The following steps can be used to create an Entity Data Model (EDM) for the Progress isports database:

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure8.80.Visual Studio 2008 SP1 IDE

    Visual Studio 2008 SP1 IDE

  2. Create a

    Web Application

    project by going to the


    menu in Visual Studio and choosing

    New Project


    Figure8.81.Web Application

    Web Application

  3. When the New Project window appears, choose either

    Visual Basic


    Visual C#

    as your programming language.

  4. Within the language category, click on


    and select

    ASP.NET Web Application

    from the right-hand panel.

  5. Choose a name for the project, for example


    , and click



    Figure8.82.Name for the project

    Name for the project

  6. This will create a new project called



    Figure8.83.create a new project

    create a new project

  7. Select the Project -> Add New Item menu option.

    Figure8.84.New Item

    New Item

  8. The

    Add New Item

    dialog will appear. Choose the

    ADO.NET Entity Data Model

    template. Give it the name


    and click


    to start the creation of the ADO.Net Entity Data Model.

    Figure8.85.Add New Item

    Add New Item

  9. In the

    Entity Data Model Wizard


    Choose Model Contents

    page select the

    Generate from Database

    model type and click



    Figure8.86.Choose Model Contents

    Choose Model Contents

  10. In the

    Entity Data Model Wizard


    Choose your Data Connection

    page, select the

    New Connection button

    Figure8.87.Entity Data Model Wizard

    Entity Data Model Wizard

  11. In the

    Choose Data Source

    dialog, select the OpenLink

    Virtuoso Data Source

    from the list and click



    Figure8.88.Choose Data Source

    Choose Data Source

  12. In the

    Add Connection

    dialog, specify the

    hostname, portno, username and password

    for the target Virtuoso Server and check the Save Password check box.

    Figure8.89.Connection Properties

    Connection Properties

  13. Select the

    Select Database From List

    radio button and choose the


    database from the drop down list.

    Figure8.90.Add connection

    Add connection

  14. Press the

    Test Connection

    dialog to verify that the database is accessible.

    Figure8.91.Test Connection

    Test Connection

  15. Set the

    entity connect string

    name to


    (note this name as it is required in the section on creating and ADO.Net Data Service) and click



    Figure8.92.entity connect string

    entity connect string

  16. In the

    Choose your Database Objects

    page select the


    check box to select all tables in the isports catalog for addition to the Entity Data Model. Set the

    Model Namespace



    and click



    Figure8.93.Database Objects

    Database Objects

  17. The


    EDM will be created with the tables and relationships displayed in the Visual Studio IDE.



Creation for the Entity Data Model for the Progress isports database is now complete.