Chapter 15 DBMS-Specific Features

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.

Creating a CLR trigger

To create a CLR trigger, you must have an OOM open in the workspace, in order to specify an associated class method.

To create a CLR trigger:

1. Create a standard trigger.
2. On the Definition Tab of its property sheet, select CLR Trigger from the template list. A Class method field will be displayed to the right of the template list.
3. Click the Select Method tool to the right of the Class method field, in order to specify the associated method.
4. Click the Microsoft tab and select an assembly from the list to bind to the trigger.
5. Click OK to close the property sheet.

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:

Copyright (C) 2006. Sybase Inc. All rights reserved.