Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.
Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they're enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies when they should and should not be used, what you can do with them, and how you can get the most out of them.
The book provides an in-depth tutorial on building and using assemblies. It will focus on building assemblies in C# code, but will provide the equivalent VB.NET code in the code download. Alongside this tutorial comes a detailed examination of exactly when assemblies should and should not be used. Assemblies are not a complete replacement for T-SQL stored procedures and triggers, but are enhancements, to be used at the right place at the right time. After reading this book, the reader will be able to build robust, useful and intelligent assemblies that are safe to execute and secure to the organization.
Robin Dewson
.NET C# Debugging Microsoft SQL Server SQL SQL Server 2005 T-SQL Transact-SQL programming