8.13.4. Creating EDM in Visual Studio 2008

The following steps can be used to create an Entity Data Model (EDM) for the Microsoft SQL Server Northwind database:

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure 8.661. 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


  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



    Figure 8.662. name for the project

    name for the project

  6. This will create a new project called



    Figure 8.663. create a new project

    create a new project

  7. Right click on the VirtuosoDataService project name of the Solution Explorer pane, then select the Add -> New Item menu options.

    Figure 8.664. VirtuosoDataService


  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.

    Figure 8.665. 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



    Figure 8.666. Choose Model Contents

    Choose Model Contents

  10. In the

    Entity Data Model Wizard


    Choose your Data Connection

    page, select the

    New Connection button

    Figure 8.667. 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



    Figure 8.668. 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 click the Advanced button.

    Figure 8.669. Connection Properties

    Connection Properties

  13. Use the Select Database From List dialog to select the NWIND catalog.

    Figure 8.670. Add connection

    Add connection

  14. Press the

    Test Connection

    dialog to verify that the database is accessible. Click "OK" to persist the connection attributes, after a successful connection is verified.

    Figure 8.671. 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



    Figure 8.672. entity connect string

    entity connect string

  16. In the

    Choose your Database Objects

    page select the


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

    Model Namespace



    and click



    Figure 8.673. Database Objects

    Database Objects

  17. The


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

    Figure 8.674. Virtuoso.edmx


Creation for the Entity Data Model for the Microsoft SQL Server Northwind database is now complete.