VOS.VirtMySQLEDM

  • Topic
  • Discussion
  • VOS.VirtMySQLEDM(Last) -- DAVWikiAdmin? , 2017-06-29 07:38:40 Edit WebDAV System Administrator 2017-06-29 07:38:40

    Creating an Entity Data Model (EDM) for the MySQL Northwind database

    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.



    2. Create a Web Application project by going to the File menu in Visual Studio and choosing New Project.

    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.



    6. This will create a new project called VirtuosoDataService.



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



    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.



    9. In the Entity Data Model Wizard dialog Choose Model Contents page, select the Generate from Database model type and click Next.



    10. In the Entity Data Model Wizard dialog Choose your Data Connection page, select the New Connection button.



    11. In the Choose Data Source dialog, select the OpenLink Virtuoso Data Source from the list and click Continue.



    12. In the Add Connection dialog, specify the hostname, portno, username, and password for the target Virtuoso Server and and check the Save Password check box.



    13. Select the Select Database From List radio button and choose the mysql database from the drop down list.



    14. Press the Test Connection dialog to verify the database is accessible.



    15. Click OK to add the 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.



    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 Enity Data Model. Set the Model Namespace to VirtuosoModel and click Finish.



    18. The Virtuoso.edmx EDM will be created with the tables and relationships displayed in the Visual Studio IDE.



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