CLR Procedures and Functions

In Microsoft SQL Server 2005, you can write user-defined functions in any Microsoft .NET Framework programming language, such as Microsoft Visual Basic .NET or Microsoft Visual C#. PowerDesigner models CLR procedures and functions as standard procedures that use a CLR template, and are linked to a method from an associated OOM.

CLR Procedure or Function Properties

You can modify an object's properties from its property sheet. To open a CLR procedure or function property sheet, double-click its diagram symbol or its Browser entry in the Procedures folder.

The following extended attributes are available on the Microsoft tab:

Name	Description
Assembly	Specifies the assembly where the class method is defined. Scripting name: Assembly

Name

Description

Assembly

Specifies the assembly where the class method is defined.

Scripting name: Assembly

Creating a CLR Procedure or Function
To create a CLR procedure or function, you must have already created an assembly, and you must have an OOM open in the workspace, in order to specify an associated class method.

Parent topic: Common Language Runtime (CLR) Integration