CHAPTER 21 ADO.NET PART I: THE CONNECTED LAYER
Note You will use the AutoLot database throughout the rest of this book.
Creating the Inventory Table
To begin building your testing database, launch Visual Studio and open the Server Explorer using the
View menu of the IDE. Next, right-click the Data Connections node and select the Create New SQL
Server Database menu option (see Figure 21-3).
Figure 21-3. Creating a new SQL Server database within Visual Studio
In the resulting dialog box, you will need to enter a value into the Server name text area, which
represents the machine where the database will be created. If you have installed a full version of
Microsoft SQL Server on your machine, enter (local) to represent that you will create the database on
your current local machine. However, if you are using Microsoft SQL Express, enter (local)\SQLEXPRESS.
Name your new database AutoLot (Windows Authentication should be fine; see Figure 21-4).
816