Table of Contents

Class SqlForeignKey

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

Represents a foreign key in a table for a SQL server database.

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

Constructors

SqlForeignKey()

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

public SqlForeignKey()

Properties

Columns

Gets or sets the names of the columns in the parent table.

public SerializableStringCollection Columns { get; set; }

Property Value

SerializableStringCollection

DeleteAction

Gets or sets the foreign key delete action.

public SqlForeignKeyAction DeleteAction { get; set; }

Property Value

SqlForeignKeyAction

DeleteActionString

Gets the foreign key delete action as a human readable string.

public string DeleteActionString { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the foreign key.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

Identifier

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

public Guid Identifier { get; set; }

Property Value

Guid

IsChecked

Gets or sets whether the foreign key is checked.

public BooleanOption IsChecked { get; set; }

Property Value

BooleanOption

IsEnabled

Gets or sets whether the foreign key is enabled.

public BooleanOption IsEnabled { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the column.

public string Name { get; set; }

Property Value

string

NotForReplication

Gets or sets the foreign key is not for replication.

public BooleanOption NotForReplication { get; set; }

Property Value

BooleanOption

ParentTableName

Gets or sets the name of the table in which the foreign key is defined.

public string ParentTableName { get; set; }

Property Value

string

ReferencedColumns

Gets or sets the names of the columns in the referenced table.

public SerializableStringCollection ReferencedColumns { get; set; }

Property Value

SerializableStringCollection

ReferencedTableName

Gets or sets the name of the table referenced by the foreign key.

public string ReferencedTableName { get; set; }

Property Value

string

UpdateAction

Gets or sets the foreign key update action.

public SqlForeignKeyAction UpdateAction { get; set; }

Property Value

SqlForeignKeyAction

UpdateActionString

Gets the foreign key update action as a human readable string.

public string UpdateActionString { get; set; }

Property Value

string

Methods

Clone()

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

public SqlForeignKey Clone()

Returns

SqlForeignKey

A CENTREL.XIA.Configuration.Types.SqlForeignKey.

CompareTo(SqlForeignKey)

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

public int CompareTo(SqlForeignKey other)

Parameters

other SqlForeignKey

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

Returns

int

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