Teach Yourself Visual Studio® .NET 2003 in 21 Days [Electronic resources]

Jason Beres

نسخه متنی -صفحه : 270/ 243
نمايش فراداده

Exercises

  1. Using the original ORM model that you created, add a Manufacturer role that has an inverse relationship with the Products role.

    The question you should use is

    Manufacturers create Products
     

    The inverse relationship is

    Products are created by Manufacturers
     

    Add a few value references for the Manufacturer role, such as ManufacturerName, ManufacturerCity, and so on. You should also add an entity reference called ManufacturerID for the Manufacturer object.

    After you've done that, re-create the database diagram and re-create the ORM_Test database in SQL Server.

  2. In Visio, use the Reverse Engineer option from the Database menu in a new Database Diagram project. Reverse-engineer the Northwind database in your MSDE database, and study how the database was created based on the conceptual model that was reverse-engineered.