Integrate DotNet in Sql Server 2005 [25 mn de lecture - paru le 10/29/2005 6:06:13 PM - Public : Confirmé]

Auteur

Michel DEGREMONT Elève-Ingénieur Supinfo Paris Promotion SUPINFO 2006    Lui écrire    Tous les projets de cet auteur    Le mini-CV de cet auteur

Introduction

Sql Server 2005 and Visual Studio 2005 bring a new way to us of working. To through this article I will fly over a negligible part of the new evolutions of Visual Studio 2005 and Sql Server 2005.

We particularly will interest we in the integration of the CLR in SQL Server 2005. You will be able to create functions, aggregates, stored procedures and triggers in a Net language like C #, VB.net, C++...

You will also be able to create your clean type given to adapt to your activity, with your project.

I will try to show you the integration of code CLR with simple examples starting from Visual Studio 2005, last version of Visual Studio and FrameWork.

In my examples I will use C # like language of development.

Into pre required you must have installed Visual Studio 2005 and Sql Server 2005.

http://msdn.microsoft.com/SQL/2005/

http://lab.msdn.microsoft.com/express/

You must have also created a user SQL named "Michel" as well as a Base of data "Supinfo" containing a named table "Project"