Table of Contents

Class SqlTrigger

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a trigger for a table in a SQL server database.

public class SqlTrigger : BaseTypeSection, IComparable<SqlTrigger>
Inheritance
SqlTrigger
Implements

Constructors

SqlTrigger()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlTrigger class.

public SqlTrigger()

Properties

AnsiNullsStatus

Gets or sets the ANSI NULLs status for the trigger.

public BooleanOption AnsiNullsStatus { get; set; }

Property Value

BooleanOption

CreationScript

Gets or sets the SQL script used to create the trigger.

public SqlScript CreationScript { get; set; }

Property Value

SqlScript

DateCreated

Gets or sets the date and time the trigger was created.

public DateTime DateCreated { get; set; }

Property Value

DateTime

DateLastModified

Gets or sets the date and time the trigger was last modified.

public DateTime DateLastModified { get; set; }

Property Value

DateTime

Description

Gets or sets the description of the trigger.

public string Description { get; set; }

Property Value

string

ExecutionContext

Gets or sets the execution context for the trigger.

public SqlExecutionContext ExecutionContext { get; set; }

Property Value

SqlExecutionContext

ExecutionContextPrincipal

Gets or sets the user account for which to execute the code.

public string ExecutionContextPrincipal { get; set; }

Property Value

string

ExecutionContextString

Gets the execution context.

public string ExecutionContextString { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the trigger.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

Identifier

Gets or sets the unique identifier for the trigger. This is for internal use only.

public Guid Identifier { get; set; }

Property Value

Guid

IsEnabled

Gets or sets whether the trigger is enabled.

public BooleanOption IsEnabled { get; set; }

Property Value

BooleanOption

IsEncrypted

Gets or sets whether the trigger is encrypted.

public BooleanOption IsEncrypted { get; set; }

Property Value

BooleanOption

IsSystemObject

Gets or sets whether the trigger is a system object.

public BooleanOption IsSystemObject { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the trigger.

public string Name { get; set; }

Property Value

string

QuotedIdentifierStatus

Gets or sets the quoted identifier status for the trigger.

public BooleanOption QuotedIdentifierStatus { get; set; }

Property Value

BooleanOption

Methods

Clone()

Returns a CENTREL.XIA.Configuration.Types.SqlTrigger cloned from this object.

public SqlTrigger Clone()

Returns

SqlTrigger

A CENTREL.XIA.Configuration.Types.SqlTrigger.

CompareTo(SqlTrigger)

Compares two CENTREL.XIA.Configuration.Types.SqlTrigger objects to allow sorting alphabetically by name.

public int CompareTo(SqlTrigger other)

Parameters

other SqlTrigger

The CENTREL.XIA.Configuration.Types.SqlTrigger to compare to.

Returns

int

The sort order of the two CENTREL.XIA.Configuration.Types.SqlTrigger objects.