Free mag vol1 | Page 875

CHAPTER 21  ADO.NET PART I: THE CONNECTED LAYER Figure 21-9. Designing the Customers table After you save and name your table, add a handful of customer records (see Figure 21-10). Figure 21-10. Populating the Customers table You will use your final table, Orders, to represent the automobile a given customer is interested in purchasing. Do this by mapping OrderID values to CarID/CustID values. Figure 21-11 shows the structure of your final table (again, note that OrderID is the primary key). 821