8.11.4.Using EDM to create Entity Framework based applications

Now that a Microsoft Entity Data Model has been created for the Northwind database, Entity Framework applications can be created to make use of it.

Visual Studio Windows DataGrid Form Application

This section details the steps required to create a simple Visual Studio 2008 Windows Form application, with associated DataGridView control for displaying data in selected tables from the target database.

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure8.573.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.574.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

    Windows

    and select

    Windows Form Application

    from the right-hand panel.

  5. Choose a name for the project, for example

    VirtWindowsFormApplication

    , and click

    OK

    .

    Figure8.575.Web Application

    Web Application

  6. In the

    Toolbox

    , expand

    Data Controls

    , and drag the

    DataGridView

    control onto the form.

    Figure8.576.Toolbox

    Toolbox

  7. Click on the little

    arrow

    in the top right of the

    DataGridView

    control. This loads the

    DataGridView Task

    menu.

    Figure8.577.DataGridView Task

    DataGridView Task

  8. Click on the

    Choose Data Source

    list box.

    Figure8.578.Choose Data Source

    Choose Data Source

  9. Click on the

    Add Project Data Source

    link to connect to a data source.

    Figure8.579.Add Project Data Source

    Add Project Data Source

  10. In the

    Data Source Configuration Wizard

    dialog

    Choose Data Source Type

    page select the

    Database

    data source type and click

    Next

    .

    Figure8.580.Data Source Type

    Data Source Type

  11. In the

    Data Source Configuration Wizard

    dialog

    Choose your Data Connection

    page, select the

    New Connection

    button

    Figure8.581.Data Source Configuration Wizard

    Data Source Configuration Wizard

  12. In the

    Choose Data Source

    dialog, select the OpenLink

    Virtuoso Data Source

    from the list and click

    Continue

    .

    Figure8.582.Data Source

    Data Source

  13. 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.583.Connection Properties

    Connection Properties

  14. Select the

    Select Database From List

    radio button and choose the

    NWIND

    database from the drop down list.

    Figure8.584.Add connection

    Add connection

  15. Press the

    Test Connection

    dialog to verify that the database is accessible.

    Figure8.585.Test Connection

    Test Connection

  16. Leave the default connect string

    NWINDConnectionString

    and click

    Next

    Figure8.586.NWINDConnectionString

    NWINDConnectionString

  17. From the list of available tables returned for the NWIND database, select the

    JOBS

    table to be associated with the

    DataGridView

    control.

    Figure8.587.Northwind database

    Northwind database

  18. The columns names of the select table will be displayed in the DataGridView.

    Figure8.588.DataGridView

    DataGridView

  19. Resize the Form and DataGridView to allow all columns to be visible, if possible.

    Figure8.589.Resize the Form and DataGridView

    Resize the Form and DataGridView

  20. To test the application, simply hit

    Ctrl+F5

    within Visual Studio or select

    Start Debugging

    from the

    Debug

    menu.

    Figure8.590.Start Debugging

    Start Debugging

  21. The data from the

    Products

    table will be displayed in the

    DataGrid

    .

    Figure8.591.DataGrid

    DataGrid

The task is now complete.