Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

Using Microsoft Visual Studio 2005 to Simplify Building SQL CLR Code

During the early betas of SQL Server 2005, the most frequently asked questions on developer forums were the following: "How do I build my .NET assembly?" "How do I deploy my .NET assembly to SQL Server?" "How do I register my assembly so that I can access my new stored procedure, function, or type?" The most frequent answer to these questions started with "Open a SQL Server Project in Visual Studio 2005."

If you have both Visual Studio 2005 and SQL Server 2005 installed on the same machine, there’s a new project template available to Visual Basic and C# developers—the SQL Server project. Working with a SQL Server project from Visual Studio 2005 can greatly simplify the process ...