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

1. My first application  DotNet in Sql Server 2005

1.1. Visual Studio 2005

To launch Visual Studio 2005 .

To create a new project: Sql Server Project in language C #.

This project has the references necessary for the handling of Objects of SQL Server 2005 in NET

To refer the data base on which you will work. While choosing your base you will be able to deploy your assembly in simple clicks right.( cf 2.2 To deploy your procedure on Sql Server 2005 )

1.2. To activate the debugger

Visual Studio 2005 asks to you whether you wish to activate debogor SQL CLR... Mode déboguer of the Serveur code which is carried out in the same process as Sql waiter 2005. Sql Server will create an authority of the CRL 2.0 of Windows to lodge its own authority. Of course it is disadvised of déboguer on a waiter of production to avoid any useless overload of the CPU.

1.3. Models of classes

You will also be able to serve to you as the model classes provided by Visual Studio 2005 which contain the System.Data.SqlServer directive

In the Solution To explore one can directly create a new function, strore procedure, aggregate, release, a type of data...