SQL - Extended
1.0.0
Pi-Con: Small utilities makes the difference
|
The Attribute Foreign Key for the relations in the database. More...
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... | |
The Attribute Foreign Key for the relations in the database.
PiCon.SQL.ForeignKeyAttribute.ForeignKeyAttribute | ( | Type | fkTableType, |
string | fkColumnName = "Id" |
||
) |
Constructor for the Foreign Key Attribute
|
getset |
The ForeignKey Column in the (parent) Table
|
getset |
The Foreign key Table (parent)
|
get |
The name of the Foreign Key, used in the create table function
|
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.
|
getset |
The Match option for the Foreign Key, see SQLite-Net documenation for more details.
|
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.