Summary
In this chapter, we’ve exposed you to the “mechanics” of developing the five basic SQL CLR entities and using them from T-SQL. You’ve seen how to take advantage of the SQL Server 2012/Visual Studio 2010 integration, as well as how to develop SQL CLR code in conventional Class Library assemblies and deploy them using T-SQL. You’ve also learned most of the SQL CLR .NET code attributes and their use in SQL Server Database Projects as well as in standard Class Library projects.
You should now have a sense of how to use SQL Server Management Studio and the Visual Studio 2010 SQL Server Data Tools (SSDT) as management tools for your SQL CLR objects. We’ve discussed scenarios in which using SQL CLR integration is a good choice, as well as scenarios ...
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.
