2.7. Visual Studio 2005

SQL Server 2005 hosts the .NET Common Language Runtime (CLR) in the Database Engine. This lets you create database objects such as functions, stored procedures, triggers, user-defined data types, and user-defined aggregate functions in programming languages supported by the CLR. Visual Studio 2005 supports CLR integration into SQL Server with a new project type named SQL Server Project. Once the compiled assembly for a SQL Server project is registered with SQL Server, the database objects in the assembly can be used the same way as if they had been created using T-SQL. Chapters 4 and 5 discuss SQL Server 2005 CLR integration and programming database objects using Visual Studio 2005.