CLR Triggers

The Microsoft SQL Server integration with the .NET Framework common language runtime (CLR), allows you to use any .NET Framework language to create CLR triggers. PowerDesigner CLR triggers as standard triggers that use a CLR template, and are linked to a method from an associated OOM.

CLR Trigger Properties

You can modify an object's properties from its property sheet. To open a CLR trigger property sheet, double-click its Browser entry.

The following extended attributes are available on the SQL Server 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 Trigger
To create a CLR 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.

Parent topic: Common Language Runtime (CLR) Integration