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:
-
Launch the Visual Studio 2008 SP1 IDE.
Figure 8.404. 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.405. 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
Web
and select
ASP.NET Web Application
from the right-hand panel.
-
Choose a name for the project, for example
VirtuosoDataService
, and click
OK
.
Figure 8.406. name for the project
-
This will create a new project called
VirtuosoDataService
.
Figure 8.407. create a new project
-
Select the Project -> Add New Item menu option.
Figure 8.408. VirtuosoDataService
-
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.
Figure 8.409. Add New Item
-
In the
Entity Data Model Wizard
dialog
Choose Model Contents
page select the
Generate from Database
model type and click
Next
.
Figure 8.410. Choose Model Contents
-
In the
Entity Data Model Wizard
dialog
Choose your Data Connection
page, select the
New Connection button
Figure 8.411. Entity Data Model Wizard
-
In the
Choose Data Source
dialog, select the OpenLink
Virtuoso Data Source
from the list and click
Continue
.
Figure 8.412. Choose 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.413. Connection Properties
-
Select the
Select Database From List
radio button and choose the
mysql
database from the drop down list.
Figure 8.414. Add connection
-
Press the
Test Connection
dialog to verify that the database is accessible.
Figure 8.415. Test Connection
-
Click OK to add the connection.
Figure 8.416. Test Connection
-
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
.
Figure 8.417. entity connect string
-
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
.
Figure 8.418. Database Objects
-
The
Virtuoso.edmx
EDM will be created with the tables and relationships displayed in the Visual Studio IDE
Figure 8.419. Virtuoso.edmx
Creation for the Entity Data Model for the MySQL Northwind database is now complete.