/ Assembly List / LJCDataUtility / ProcBuilder

Namespace - LJCDataUtility


Syntax

C#
private class ProcBuilder

Provides procedure SQL code.

Public Methods
ToString Returns the builder string.
1 Methods

Private Methods
#ctor Initializes an object instance.
AddForeignKey Adds a foreign key.
AddPrimaryKey Adds a primary key.
AddUniqueKey Adds a unique key.
Begin Adds the Procedure begin code.
BodyBegin Creates the Proc body code.
Check Checks for the database object.
ColumnsList Creates the insert Columns list.
CreateTable Returns Create Table SQL.
CreateTableProc Complete Create Table procedure.
DropConstraint Drops the constraint by provided name.
IFItem Gets the Table row IF statement.
NameAndType Get column name and type.
Parameters Creates the Parameters.
RenameTableSQL Renames a table. Removes old keys and creates new keys.
Reset Resets the text values.
SQLDeclaration Creates a SQL Declaration variable from a DataUtilityColumn.
SQLVarName Creates a SQL variable name from a column name.
TableBegin Adds the Table begin SQL.
TableColumn Adds a table column definition.
TableEnd Creates the Table end code.
TableIdentity Creates the Identity column.
ValuesList Creates the Values list.
23 Methods

Properties
AddProcName Gets or sets the Add data Procedure Name.
BeginDelimiter The beginning identifier delimiter.
CreateProcName Gets or sets the Create Table Procedure Name.
DBName Gets or sets the Database Name.
EndDelimiter The ending identifier delimiter.
ForeignKeyDropProcName Gets or sets the Create Foreign Key Drop Procedure Name.
ForeignKeyProcName Gets or sets the Create Foreign Key Procedure Name.
PKName Gets or sets the Primary Key Name.
TableName Gets or sets the Table Name.
UQName Gets or sets the Unique Key Name.

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.