CHAPTER 21 ADO.NET PART I: THE CONNECTED LAYER
Figure 21-8. The GetPetName stored procedure
Creating the Customers and Orders Tables
The AutoLot database will have two additional tables: Customers and Orders. The Customers table (as the
name suggests) will contain a list of customers and will be represented by three columns: CustID (which
should be set as the primary key), FirstName, and LastName. You can create the Customers table by
following the same steps you used to create the Inventory table; be sure to create the Customers table
using the schema shown in Figure 21-9.
820