A user-defined function that writes managed in C #

Brief introduction

With the integration of the CLR in SQL Server 2005, we can build database objects using modern object-oriented languages such as vb.net,c#.

This article will use simple and necessary steps to show you how to start using C # to establish a managed user custom function.

Xu Eye

We will build a visual Studio 2005 database project for managed triggers

Building a database project

Open Microsoft Visual Studio 2005 to create a SQL Server project

file->new->project->database

Add a database reference now it will need a reference to the database, add one.

Add a user-defined function

Right-click the project and create a user-defined function

The file Function1.cs: