May 2006
Intermediate to advanced
720 pages
17h 18m
English
Content preview from Microsoft® Visual C# 2005 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 21. Programming with SQL Server 2005
IN THIS CHAPTER
- Introduction to the SQL Server 2005 CLR Host
- Building C# Stored Procedures
- Building C# User-Defined Functions
- Creating a C# User-Defined Type
- Working with the New Server-Side SQL Library
- Using MARS (Multiple Active RecordSets)
SQL Server 2005 adds a wealth of new features for developers and DBAs alike. One of the biggest new features of SQL Server 2005 of interest to C# developers is the integration of the CLR directly into the server. This gives SQL Server 2005 the ability to host stored procedures, user-defined functions, user-defined types, and much more—all written in managed code.
The ability to reuse your existing .NET and C# skills from within SQL Server 2005, as well as have ...