In Microsoft SQL Server 2005, you can write user-defined procedures, functions, and triggers in any Microsoft .NET Framework programming language. PowerDesigner models these objects as standard procedures and triggers that use a CLR template, and are linked to a method from an associated OOM.
Creating a CLR Procedure, Function, or Trigger
To create a CLR procedure, function, or trigger 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:
- Create a standard procedure or function and, on the Definition Tab of its property sheet, select CLR Procedure, CLR Function, or CLR Trigger from the template list. A Class method field will be displayed to the right of the template list.
- Click the Select Method tool to the right of the Class method field, in order to specify the associated method.
- Click the Microsoft tab and select an assembly from the list to bind to the procedure or function.
CLR Procedure, Function, and Trigger Properties
You can modify an object's properties from its property sheet. To open a CLR procedure, function, or trigger property sheet, double-click its diagram symbol or its Browser entry in the Procedures or Triggers 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
|