Specifications

46 CHAPTER 3 Data-Tier Applications
4. In the Project Template pane, select Data-Tier Application.
5. Specify the name, location, and solution name for the data-tier application, as shown
in Figure 3-2, and click OK.
FIGURE 3-2 Selecting the Data-Tier Application project template in Visual Studio 2010
6. Select Project, and then click Add New Item to add and create a database object based
on the Data-Tier Application project template. Some of the database objects included
in the template are scalar-valued function, schema, table, index, login, stored proce-
dure, user, user-dened table type, view, table-valued function, trigger, user-dened
data type, database role, data generation plan, and inline function.
Figure 3-3 illustrates the syntax for creating a sample Employees table schema for a
data-tier application in Visual Studio 2010. The Solution Explorer pane also includes the
other schema objects—specically the tables associated with the data-tier application.