Open the

VirtuosoDataService

project created in the Creating EDM in Visual Studio 2008 section .

Select the Project -> Add New Item menu option.

Figure 8.189. VirtuosoDataService

The

Add New Item

dialog will appear. Choose the

ADO.NET Data Service template

. Give it the name

Virtuoso.svc

, and click

Add

to create the ADO.Net Data Service.

Figure 8.190. Add New Item

In the newly created

Virtuoso.svc.cs

Data Service, add the data source class name of

VirtuosoEntities

(note this is the name set in the Creating EDM in Visual Studio 2008 section) as the

DataService

name. Enable the access to the Data Service by adding the entry

config.SetEntitySetAccessRule("*", EntitySetRights.All);

in the

InitializeService

method.

// C#

using System;
using System.Web;
using System.Collections.Generic;
using System.ServiceModel.Web;
using System.Linq;
using System.Data.Services;

namespace SimpleDataService
{
    public class Northwind : DataService<VirtuosoDemoEntities>
    {
        public static void InitializeService(IDataServiceConfiguration  config)
        {
            config.SetEntitySetAccessRule("*", EntitySetRights.All);
        }
    }
}

Figure 8.191. Virtuoso.svc.cs

To test the Data Service, simply hit

Ctrl+F5

within Visual Studio. This will start the development web server, run the Data Services server inside, and load a Web browser page displaying the list of available tables/entities for the Ingres Tutorial database catalog.

Figure 8.192. Data Service test

To access a specific entity instance like the cust_orders table order number 5500 record, use this convention: http://host/vdir/Virtuoso.svc/cust_orders(5500) .

Figure 8.193. Orders

Important

- To view

Atom

(the default format returned by an ADO.NET Data Service) in Internet Explorer, you must first ensure that

Feed Reading View

is turned

off

. This can be done on the

Content tab

of

Tools in Internet Options

.

If a Data Services entity instance URI page fails to load you can turn

Verbose

errors on by adding

config.UseVerboseErrors = true;

in the

virtuoso.svc.cs InitializeService

method to obtain more detailed information from the server as to why the page failed to load:

public static void InitializeService(IDataServiceConfiguration config)

{

config.UseVerboseErrors = true;

config.SetEntitySetAccessRule("*", EntitySetRights.All);

}

Launch the Visual Studio 2008 SP1 IDE.

Figure 8.194. Visual Studio 2008 SP1 IDE

Create a

Web Application

project by going to the

File

menu in Visual Studio and choosing

New Project

.

Figure 8.195. Web Application

When the New Project window appears, choose either

Visual Basic

or

Visual C#

as your programming language.

Within the language category, click on

Windows

and select

Windows Form Application

from the right-hand panel.

Choose a name for the project, for example

VirtWindowsFormApplication

, and click

OK

.

Figure 8.196. Web Application

In the

Toolbox

, expand

Data Controls

, and drag the

DataGridView

control onto the form.

Figure 8.197. Toolbox

Click on the little

arrow

in the top right of the

DataGridView

control. This loads the

DataGridView Task

menu.

Figure 8.198. DataGridView Task

Click on the

Choose Data Source

list box.

Figure 8.199. Choose Data Source

Click on the

Add Project Data Source

link to connect to a data source.

Figure 8.200. Add Project Data Source

In the

Data Source Configuration Wizard

dialog

Choose Data Source Type

page select the

Database

data source type and click

Next

.

Figure 8.201. Data Source Type

In the

Data Source Configuration Wizard

dialog

Choose your Data Connection

page, select the

New Connection

button

Figure 8.202. Data Source Configuration Wizard

In the

Choose Data Source

dialog, select the OpenLink

Virtuoso Data Source

from the list and click

Continue

.

Figure 8.203. Data Source

In the

Add Connection

dialog, specify the

hostname, portno, username and password

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

Figure 8.204. Connection Properties

Select the

Select Database From List

radio button and choose the

TUT

database from the drop down list.

Figure 8.205. Add connection

Press the

Test Connection

dialog to verify that the database is accessible.

Figure 8.206. Test Connection

Click OK to add the connection.

Figure 8.207. Test Connection

Leave the name of the connect string to the default of

TUTConnectionString

and click

Next

Figure 8.208. TUTConnectionString

From the list of available tables returned for the TUT database, select the

cust_orders

table to be associated with the

DataGridView

control.

Figure 8.209. TUT database

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

Figure 8.210. DataGridView

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

Figure 8.211. Resize the Form and DataGridView

To test the application, simply hit

Ctrl+F5

within Visual Studio or select

Start Debugging

from the

Debug

menu.

Figure 8.212. Start Debugging

The data from the

cust_orders

table will be displayed in the

DataGrid

.

Figure 8.213. DataGrid