Murach's SQL Server 2008 for Developers
An introduction to CLR integration

The .NET Framework's Common Language Runtime (CLR) allows you to use any .NET language (like C# or Visual Basic) to create database objects such as stored procedures, functions, and triggers. In addition, it allows you to create new types of database objects that aren't available from T-SQL.
     This chapter introduces you to CLR integration, explaining what it is and showing you how to work with CLR objects.
Chapter 20 An introduction to CLR integration
An introduction to CLR integration 652
How CLR integration works 652
The five types of CLR objects 654
When to use CLR objects 654
How to enable CLR integration 656
How to use Visual Studio to work with CLR objects 658
How to start a SQL Server project 658
How to specify the type of CLR object 662
How to enter and edit the code for CLR objects 664
The code for a CLR object 666
How to compile and deploy CLR objects 668
How to test and debug a CLR object 670
How to use SQL to work with CLR objects 672
How to deploy an assembly 672
How to deploy a CLR object 672
How to drop an assembly 672
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.