Craig's Utility Library  4.0 Beta
Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure Class Reference

StoredProcedure class More...

Inheritance diagram for Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure:
Utilities.ORM.Manager.Schema.BaseClasses.TableBase Utilities.ORM.Manager.Schema.Interfaces.IFunction Utilities.ORM.Manager.Schema.Interfaces.ITable

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< IColumnColumns [get]
 Columns More...
 
string Name [get, set]
 Name of the table More...
 
ISource Source [get]
 Source/Parent More...
 
ICollection< ITriggerTriggers [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< IColumnColumns [get]
 Columns More...
 
string Name [get, set]
 Name More...
 
ISource Source [get]
 Parent of the table structure More...
 
ICollection< ITriggerTriggers [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...
 

Detailed Description

StoredProcedure class

Definition at line 33 of file StoredProcedure.cs.

Constructor & Destructor Documentation

Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.StoredProcedure ( string  Name,
string  Definition,
ISource  Source 
)

Constructor

Parameters
NameName
SourceSource
DefinitionDefinition of the stored procedure

Definition at line 41 of file StoredProcedure.cs.

Member Function Documentation

override IColumn Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.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 = "",
DefaultValue = default(T),
bool  OnDeleteCascade = false,
bool  OnUpdateCascade = false,
bool  OnDeleteSetNull = false 
)
virtual

Adds a column

Parameters
ColumnNameColumn Name
ColumnTypeData type
LengthData length
NullableNullable?
IdentityIdentity?
IndexIndex?
PrimaryKeyPrimary key?
UniqueUnique?
ForeignKeyTableForeign key table
ForeignKeyColumnForeign key column
DefaultValueDefault value
OnDeleteCascadeOn Delete Cascade
OnUpdateCascadeOn Update Cascade
OnDeleteSetNullOn Delete Set Null
Template Parameters
TColumn type

Implements Utilities.ORM.Manager.Schema.BaseClasses.TableBase.

Definition at line 70 of file StoredProcedure.cs.

override void Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.AddForeignKey ( string  ColumnName,
string  ForeignKeyTable,
string  ForeignKeyColumn 
)
virtual

Adds a foreign key

Parameters
ColumnNameColumn name
ForeignKeyTableForeign key table
ForeignKeyColumnForeign 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

Parameters
NameName of the trigger
DefinitionDefinition of the trigger
TypeTrigger type
Returns
The trigger specified

Implements Utilities.ORM.Manager.Schema.Interfaces.ITable.

Definition at line 92 of file StoredProcedure.cs.

Property Documentation

string Utilities.ORM.Manager.Schema.Default.Database.StoredProcedure.Definition
getset

Definition of the stored procedure

Definition at line 50 of file StoredProcedure.cs.


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