Sams Teach Yourself Visual Studio® .NET 2003 in 21 Days

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 ...