Pro SQL Server 2005 Assemblies, Apress
|
Contents |
C# Online.NET Book Review
In the past, you could write stored procedures in Transact-SQL (T-SQL), an enhanced version of the SQL relational database language. If this would not do the job, you could write an extended stored procedure or external business object.
Comes .NET and SQL Server 2005 which hosts the Common Language Runtime (CLR). Now, you can write database modules—custom data types, custom functions, stored procedures, triggers—in C# or another .NET language. Such modules can access the entire .NET Framework. External data sources can be accessed. Formatting and processing can be extended virtually without limit.
The book is an invaluable guide and tutorial to using the different types of assemblies in SQL Server 2005. Examples are plentiful and well chosen to represent common business solutions. I suggest actually working through the examples; because, despite the authors' light touch, the subject matter is heavy. Topics include accessing external data sources, accessing Web services, securing your assembly with Code Access Security (CAS), and working with images and XML data.
The authors have a very engaging, conversational writing style which reads like an expert is sitting next to you coaching you through the examples.
All source code examples are in the C# language. Visual Basic .NET equivalents are available online.
Bottom line
No professional SQL Server developer should be without Pro SQL Server 2005 Assemblies.
Other books in this series
Publisher's description
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.
About the author(s)
Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website.
Julian Skinner studied Germanic etymology to PhD level before becoming a technical editor, first at Wrox Press, then at Apress. Recently he has focusing on development and writing in Microsoft technologies and, in particular, on C# and the .NET Framework. He is co-author of Professional ADO.NET, Professional ASP Data Access, and A Programmer's Guide to SQL.
Table of Contents (abbreviated)
CHAPTER 1 Introducing Assemblies
CHAPTER 2 Writing a Simple SQL Assembly
CHAPTER 3 The SQL Server .NET Programming Model
CHAPTER 4 CLR Stored Procedures
CHAPTER 5 User-Defined Functions
CHAPTER 6 User-Defined Types
CHAPTER 7 User-Defined Aggregates
CHAPTER 8 CLR Triggers
CHAPTER 9 Error Handling and Debugging Strategies
CHAPTER 10 Security
CHAPTER 11 Integrating Assemblies with Other Technologies
