CHAPTER 21 ADO.NET PART I: THE CONNECTED LAYER
Figure 21-11. Designing the Orders table
Now add data to your Orders table. Assuming that the OrderID value begins at 1000, select a unique
CarID for each CustID value (see Figure 21-12).
Figure 21-12. Populating the Orders table
For example, the entries used in this text indicate that Dave Brenner (CustID = 1) is interested in the
black BMW (CarID = 1000), while Pat Walton (CustID = 4) has her eye on the pink BMW (CarID = 2911).
822