Free mag vol1 | Page 870

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