SQL - Extended  1.0.0
Pi-Con: Small utilities makes the difference
Public Member Functions | Properties | List of all members
PiCon.SQL.ForeignKeyAttribute Class Reference

The Attribute Foreign Key for the relations in the database. More...

Inheritance diagram for PiCon.SQL.ForeignKeyAttribute:
SQLite.IndexedAttribute

Public Member Functions

 ForeignKeyAttribute (Type fkTableType, string fkColumnName="Id")
 Constructor for the Foreign Key Attribute More...
 
- Public Member Functions inherited from SQLite.IndexedAttribute
 IndexedAttribute ()
 Constructor More...
 
 IndexedAttribute (string name, int order)
 Constructor More...
 

Properties

Type FkTypeTable [get, set]
 The Foreign key Table (parent) More...
 
string FkColumnName [get, set]
 The ForeignKey Column in the (parent) Table More...
 
string? ForeignKeyName [get]
 The name of the Foreign Key, used in the create table function More...
 
Reactions OnUpdate [get, set]
 The On Update option for the Foreign Key, works only when the PRAGMA Foreign Keys is set Default is off, see SQLite-Net documenation for more details.
More...
 
Reactions OnDelete [get, set]
 The On Delete option for the Foreign Key, works only when the PRAGMA Foreign Keys is set Default is off, see SQLite-Net documenation for more details.
More...
 
MatchReactions OnMatch [get, set]
 The Match option for the Foreign Key, see SQLite-Net documenation for more details.
More...
 
- Properties inherited from SQLite.IndexedAttribute
string Name [get, set]
 Name of the index to create More...
 
int Order [get, set]
 Ordeing of the index More...
 
virtual bool Unique [get, set]
 setting the index to a unique value More...
 

Detailed Description

The Attribute Foreign Key for the relations in the database.

Constructor & Destructor Documentation

◆ ForeignKeyAttribute()

PiCon.SQL.ForeignKeyAttribute.ForeignKeyAttribute ( Type  fkTableType,
string  fkColumnName = "Id" 
)

Constructor for the Foreign Key Attribute

Property Documentation

◆ FkColumnName

string PiCon.SQL.ForeignKeyAttribute.FkColumnName
getset

The ForeignKey Column in the (parent) Table

◆ FkTypeTable

Type PiCon.SQL.ForeignKeyAttribute.FkTypeTable
getset

The Foreign key Table (parent)

◆ ForeignKeyName

string? PiCon.SQL.ForeignKeyAttribute.ForeignKeyName
get

The name of the Foreign Key, used in the create table function

◆ OnDelete

Reactions PiCon.SQL.ForeignKeyAttribute.OnDelete
getset

The On Delete option for the Foreign Key, works only when the PRAGMA Foreign Keys is set Default is off, see SQLite-Net documenation for more details.

◆ OnMatch

MatchReactions PiCon.SQL.ForeignKeyAttribute.OnMatch
getset

The Match option for the Foreign Key, see SQLite-Net documenation for more details.

◆ OnUpdate

Reactions PiCon.SQL.ForeignKeyAttribute.OnUpdate
getset

The On Update option for the Foreign Key, works only when the PRAGMA Foreign Keys is set Default is off, see SQLite-Net documenation for more details.


The documentation for this class was generated from the following file: