Craig's Utility Library
4.0 Beta
|
StoredProcedure class More...
Public Member Functions | |
StoredProcedure (string Name, string Definition, ISource Source) | |
Constructor More... | |
override IColumn | AddColumn< T > (string ColumnName, DbType ColumnType, int Length=0, bool Nullable=true, bool Identity=false, bool Index=false, bool PrimaryKey=false, bool Unique=false, string ForeignKeyTable="", string ForeignKeyColumn="", T DefaultValue=default(T), bool OnDeleteCascade=false, bool OnUpdateCascade=false, bool OnDeleteSetNull=false) |
Adds a column More... | |
override void | AddForeignKey (string ColumnName, string ForeignKeyTable, string ForeignKeyColumn) |
Adds a foreign key More... | |
override ITrigger | AddTrigger (string Name, string Definition, TriggerType Type) |
Adds a trigger to the table More... | |
Public Member Functions inherited from Utilities.ORM.Manager.Schema.BaseClasses.TableBase | |
abstract ITrigger | AddTrigger (string Name, string Definition, Enums.TriggerType Type) |
Adds a trigger to the table More... | |
bool | ContainsColumn (string ColumnName) |
Determines if a column exists in the table More... | |
void | SetupForeignKeys () |
Sets up foreign keys More... | |
Properties | |
string | Definition [get, set] |
Definition of the stored procedure More... | |
Properties inherited from Utilities.ORM.Manager.Schema.BaseClasses.TableBase | |
ICollection< IColumn > | Columns [get] |
Columns More... | |
string | Name [get, set] |
Name of the table More... | |
ISource | Source [get] |
Source/Parent More... | |
ICollection< ITrigger > | Triggers [get] |
List of triggers associated with the table More... | |
IColumn | this[string Name] [get] |
The column specified More... | |
Properties inherited from Utilities.ORM.Manager.Schema.Interfaces.ITable | |
ICollection< IColumn > | Columns [get] |
Columns More... | |
string | Name [get, set] |
Name More... | |
ISource | Source [get] |
Parent of the table structure More... | |
ICollection< ITrigger > | Triggers [get] |
Triggers associated with the table (if source supports them) More... | |
IColumn | this[string Name] [get] |
Returns the specified column More... | |
Properties inherited from Utilities.ORM.Manager.Schema.Interfaces.IFunction | |
string | Definition [get, set] |
Definition More... | |
string | Name [get, set] |
Name More... | |
ISource | Source [get] |
Parent database More... | |
Additional Inherited Members | |
Protected Member Functions inherited from Utilities.ORM.Manager.Schema.BaseClasses.TableBase | |
TableBase (string Name, ISource Source) | |
Constructor More... | |
StoredProcedure class
Definition at line 33 of file StoredProcedure.cs.
Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.StoredProcedure | ( | string | Name, |
string | Definition, | ||
ISource | Source | ||
) |
Constructor
Name | Name |
Source | Source |
Definition | Definition of the stored procedure |
Definition at line 41 of file StoredProcedure.cs.
|
virtual |
Adds a column
ColumnName | Column Name |
ColumnType | Data type |
Length | Data length |
Nullable | Nullable? |
Identity | Identity? |
Index | Index? |
PrimaryKey | Primary key? |
Unique | Unique? |
ForeignKeyTable | Foreign key table |
ForeignKeyColumn | Foreign key column |
DefaultValue | Default value |
OnDeleteCascade | On Delete Cascade |
OnUpdateCascade | On Update Cascade |
OnDeleteSetNull | On Delete Set Null |
T | Column type |
Implements Utilities.ORM.Manager.Schema.BaseClasses.TableBase.
Definition at line 70 of file StoredProcedure.cs.
|
virtual |
Adds a foreign key
ColumnName | Column name |
ForeignKeyTable | Foreign key table |
ForeignKeyColumn | Foreign key column |
Implements Utilities.ORM.Manager.Schema.BaseClasses.TableBase.
Definition at line 81 of file StoredProcedure.cs.
override ITrigger Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.AddTrigger | ( | string | Name, |
string | Definition, | ||
TriggerType | Type | ||
) |
Adds a trigger to the table
Name | Name of the trigger |
Definition | Definition of the trigger |
Type | Trigger type |
Implements Utilities.ORM.Manager.Schema.Interfaces.ITable.
Definition at line 92 of file StoredProcedure.cs.
|
getset |
Definition of the stored procedure
Definition at line 50 of file StoredProcedure.cs.