Microsoft® Visual Studio® 2010 Unleashed

Starting a SQL CLR Project

In the Add New Project dialog box, SQL Server CLR projects are located under the Database category. Creating a new SQL Server CLR project kicks off the same Add Database Reference dialog box that you have already seen with the Server Explorer and with the Database Project; the new project structure laid down by the project wizard is shown in Figure 21.31.

Figure 21.31 A SQL Server CLR project.

The SQL Server CLR project directly supports the creation of the following database objects:

• Stored procedures

• Triggers

• Aggregates

• User-defined functions

• User-defined types

The following sections look at how to go about ...