CLR Integration in SQL Server 2005 Using Visual Studio 2005

Print Add To Favorites Email To Friend Rate This Article
CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2

page 1 of 8

Published: 21 Feb 2007

Abstract
This article is related to my previous article CLR integration in SQL Server 2005. This contains a step-by-step method of using Visual Studio for creating CLR based database objects. This also explains the method for debugging the managed code for CLR integrated objects and explains the CLR integrated functions.

by Soyuj Kumar Sahoo
Feedback

Average Rating:

Views (Total / Last 10 Days): 38798/ 63

Article Contents:

Introduction

As I discussed in my previous article, CLR is the heart of Microsoft .Net framework. In SQL Server 2005 we can create a database object inside an instance of SQL Server that programmed in an assembly created by .Net framework. Assemblies are DLL files used in an instance of SQL Server to deploy functions, stored procedures, triggers, etc. that are written in one of the managed code languages hosted by Microsoft .NET Framework.

In this article I am going to discuss how to use Visual Studio 2005 for creating CLR integrated functions. In Visual Studio 2005 there is an option for creating database projects, which is very helpful in this objective.

Let us go through an example with creating CLR integrated functions using Visual Studio 2005 and debugging it.

View Entire Article

(Page 2) »

User Comments

Title: Update?
Name: Apuma
Date: 2010-02-03 7:17:37 PM
Comment:
Can we see an example using VS 2008?

Title: Bout the article..
Name: ainOmar
Date: 2007-05-13 10:57:53 PM
Comment:
can u simply attach more samples using .net clr

Title: Nice Article
Name: Abhishek
Date: 2007-02-21 4:50:26 AM
Comment:
Nice article to work with .net CLR.

Product Spotlight