CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2
page 1 of 8
Published: 21 Feb 2007
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
Average Rating: 
Views (Total / Last 10 Days): 38506/ 80


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

User Comments

Title: Update?   
Name: Apuma
Date: 2010-02-03 7:17:37 PM
Can we see an example using VS 2008?
Title: Bout the article..   
Name: ainOmar
Date: 2007-05-13 10:57:53 PM
can u simply attach more samples using .net clr
Title: Nice Article   
Name: Abhishek
Date: 2007-02-21 4:50:26 AM
Nice article to work with .net CLR.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-25 12:38:22 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search