SqlTriggerAttribute 类

定义

public ref class SqlTriggerAttribute sealed : Attribute

[System.AttributeUsage(System.AttributeTargets.Method, AllowMultiple=false, Inherited=false)]
[System.Serializable]
public sealed class SqlTriggerAttribute : Attribute

[<System.AttributeUsage(System.AttributeTargets.Method, AllowMultiple=false, Inherited=false)>]
[<System.Serializable>]
type SqlTriggerAttribute = class
    inherit Attribute

Public NotInheritable Class SqlTriggerAttribute
Inherits Attribute

继承

Attribute

SqlTriggerAttribute

属性

AttributeUsageAttribute SerializableAttribute

示例

下面的示例演示 SqlTriggerAttribute 指定触发器的名称、目标表以及将触发触发器的事件。 有关完整的触发器示例，请参阅 SqlTriggerContext 。

[SqlTrigger(Name = @"SalesAudit", Target = "[dbo].[SalesInfo]", Event = "FOR INSERT")]
public static void SalesAudit()
{
   // Get the trigger context.
   SqlTriggerContext triggContext = SqlContext.TriggerContext;

   switch (triggContext.TriggerAction)
   {
      case TriggerAction.Insert:

      // Do something in response to the INSERT.

      break;
   }
}

<SqlTrigger(Name:="SalesAudit", Target:="[dbo].[SalesInfo]", Event:="FOR INSERT")> _
Public Shared Sub SalesAudit()
        
   Dim triggContext As SqlTriggerContext
         
   ' Get the trigger context.
   triggContext = SqlContext.TriggerContext        

   Select Case triggContext.TriggerAction
      Case TriggerAction.Insert
      
      ' Do something in response to the INSERT.
         
   End Select

End Sub

注解

有关 CLR 触发器和示例的详细信息，请参阅 SQL Server 2005 联机丛书中的“CLR 触发器”。