Deployment
Before you can test your SQL CLR code, you must deploy the assembly containing it and register the individual functions that you want recognized as stored procedures. A number of deployment methods are at your disposal; we will pause to cover them now, before discussing testing of your stored procedures and the other four basic SQL CLR entities.
Deploying Your Assembly
As mentioned earlier, Visual Studio deploys the SQL Server project version of the sample code when you build, start, or step through the project, or you can use the Build, Deploy option you’ll find on Visual Studio’s main menu. If you’re working with the SQL Server project version of the samples, go ahead and use the Deploy option or one of the Start or Build options in ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
