8.8.4.Creating EDM in Visual Studio 2008

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

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure8.404.Visual Studio 2008 SP1 IDE

    Visual Studio 2008 SP1 IDE

  2. Create a

    Web Application

    project by going to the

    File

    menu in Visual Studio and choosing

    New Project

    .

    Figure8.405.Web Application

    Web Application

  3. When the New Project window appears, choose either

    Visual Basic

    or

    Visual C#

    as your programming language.

  4. Within the language category, click on

    Web

    and select

    ASP.NET Web Application

    from the right-hand panel.

  5. Choose a name for the project, for example

    VirtuosoDataService

    , and click

    OK

    .

    Figure8.406.name for the project

    name for the project

  6. This will create a new project called

    VirtuosoDataService

    .

    Figure8.407.create a new project

    create a new project

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

    Figure8.408.VirtuosoDataService

    VirtuosoDataService

  8. The

    Add New Item

    dialog will appear. Choose the

    ADO.NET Entity Data Model

    template. Give it the name

    Virtuoso.edmx

    and click

    Add

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

    Figure8.409.Add New Item

    Add New Item

  9. In the

    Entity Data Model Wizard

    dialog

    Choose Model Contents

    page select the

    Generate from Database

    model type and click

    Next

    .

    Figure8.410.Choose Model Contents

    Choose Model Contents

  10. In the

    Entity Data Model Wizard

    dialog

    Choose your Data Connection

    page, select the

    New Connection button

    Figure8.411.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

    Continue

    .

    Figure8.412.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.413.Connection Properties

    Connection Properties

  13. Select the

    Select Database From List

    radio button and choose the

    mysql

    database from the drop down list.

    Figure8.414.Add connection

    Add connection

  14. Press the

    Test Connection

    dialog to verify that the database is accessible.

    Figure8.415.Test Connection

    Test Connection

  15. Click OK to add the connection.

    Figure8.416.Test Connection

    Test Connection

  16. Set the

    entity connect string

    name to

    VirtuosoEntities

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

    Next

    .

    Figure8.417.entity connect string

    entity connect string

  17. In the

    Choose your Database Objects

    page tick the

    Tables

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

    Model Namespace

    to

    VirtuosoModel

    and click

    Finish

    .

    Figure8.418.Database Objects

    Database Objects

  18. The

    Virtuoso.edmx

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

    Figure8.419.Virtuoso.edmx

    Virtuoso.edmx

Creation for the Entity Data Model for the MySQL Northwind database is now complete.