Free mag vol1 | Page 876

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