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 in this section, before discussing testing of your stored procedures and the other four basic SQL CLR entities.
Getting Ready
If you’re using a SQL Server Database Project, you’ll deploy your assembly using SSDT’s Publish function. But before doing so, you must be able to build the project successfully. A build will not only compile the SQL CLR assembly itself, but will also check the code for various errors, including unresolved references to database objects.
Go ahead and build the project ...
Get Programming Microsoft® SQL Server® 2012 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.
