Class DBMetaScript
Inheritance
System.Object
DBMetaScript
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Assembly: Terrasoft.Core.dll
public abstract class DBMetaScript
Constructors
Declaration
Declaration
protected DBMetaScript(UserConnection userConnection)
Parameters
Fields
Declaration
protected CustomQuery _columnForeignKeyQuery
Field Value
Declaration
protected CustomQuery _foreignKeyQuery
Field Value
Declaration
protected CustomQuery _foreignKeysQuery
Field Value
Declaration
protected CustomQuery _indexQuery
Field Value
Declaration
protected CustomQuery _triggerQuery
Field Value
Declaration
protected const int CascadeDeleteAction = 1
Field Value
Type |
Description |
System.Int32 |
|
Properties
Declaration
protected DataValueTypeDBMetaTypeConverter DataValueTypeDBMetaTypeConverter { get; }
Property Value
Declaration
protected DataValueTypeManager DataValueTypeManager { get; }
Property Value
Declaration
protected DBEngine DBEngine { get; }
Property Value
Declaration
protected DBMetaEngine DBMetaEngine { get; }
Property Value
Declaration
protected DBSecurityEngine DBSecurityEngine { get; }
Property Value
Declaration
protected IDbStructureReader DbStructureReader { get; set; }
Property Value
Declaration
protected GuidDBMetaTypeConverter GuidDBMetaTypeConverter { get; }
Property Value
Declaration
public bool IsAlwaysRegenerateColumnMetaPropertyData { get; set; }
Property Value
Type |
Description |
System.Boolean |
|
Declaration
protected bool IsForceIndexRebuild { get; set; }
Property Value
Type |
Description |
System.Boolean |
|
Declaration
protected LocalizableStringDBMetaTypeConverter LocalizableStringDBMetaTypeConverter { get; }
Property Value
Declaration
protected ReferenceSchemaCollectionDBMetaTypeConverter ReferenceSchemaCollectionDBMetaTypeConverter { get; }
Property Value
Declaration
public abstract TriggerType TriggerBeforeInsertUpdateActionTriggerType { get; }
Property Value
Declaration
protected UserConnection UserConnection { get; set; }
Property Value
Declaration
public DBMetaScriptValidationMessageCollection ValidationMessages { get; }
Property Value
Methods
Declaration
protected abstract void AddColumnCreatingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction, ColumnAction columnAction)
Parameters
Declaration
public virtual void AddColumnDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, string entitySchemaName, EntitySchemaColumn entitySchemaColumn)
Parameters
Declaration
protected virtual void AddColumnEditingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected IndexAction AddColumnIndexDeletingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Returns
Declaration
protected void AddColumnIndexEditingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected abstract void AddColumnIndexesDeletingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected abstract void AddColumnIndexesEditingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected virtual IndexAction AddColumnIndexRenamingActions(DBMetaActionCollection actions, ColumnAction columnAction, string indexName)
Parameters
Returns
Declaration
protected abstract void AddColumnIndexSavingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected abstract void AddColumnModificationActions(DBMetaActionCollection actions, IDataReader dataReader, EntitySchemaColumn sourceColumn, ColumnAction columnAction)
Parameters
Declaration
protected abstract void AddColumnParametersToActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction, DBMetaPropertyCollection existingProperties, DataValueType dbDataValueType, DataValueType dataValueType, string entitySchemaName)
Parameters
Declaration
protected virtual ColumnAction AddColumnRenamingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Returns
Declaration
protected abstract void AddColumnSavingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction, EntitySchemaColumn entitySchemaColumn)
Parameters
Declaration
protected abstract void AddColumnsCreatingActions(DBMetaActionCollection actions, EntitySchemaAction action)
Parameters
Declaration
protected void AddColumnsDeletingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)
Parameters
Declaration
protected void AddCreateNotExistColumnActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)
Parameters
Declaration
protected void AddDanglingReferenceValidateSavingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
public virtual void AddDBSchemaNameParameter(IParametrizedQuery query)
Parameters
Declaration
protected abstract void AddDefValueEditingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
protected virtual DefValueAction AddDefValueRenamingActions(DBMetaActionCollection actions, ColumnAction columnAction, string defValueName)
Parameters
Returns
Declaration
protected abstract void AddDefValueSavingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Adds saving actions for schema structure.
Declaration
public virtual void AddEntitySchemaBaseStructureSavingActions(DBMetaActionCollection actions, EntitySchema entitySchema)
Parameters
Declaration
protected virtual void AddEntitySchemaCreatingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction, bool skeepForeignKeyActions = false)
Parameters
Declaration
public void AddEntitySchemaDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema)
Parameters
Declaration
protected virtual void AddEntitySchemaEditingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)
Parameters
AddEntitySchemaIndexRenamingActions(DBMetaActionCollection, IndexAction, String)
Declaration
protected virtual IndexAction AddEntitySchemaIndexRenamingActions(DBMetaActionCollection actions, IndexAction indexAction, string indexName)
Parameters
Returns
AddEntitySchemaIndexSavingActions(DBMetaActionCollection, EntitySchemaAction, EntitySchemaIndex)
Declaration
protected abstract void AddEntitySchemaIndexSavingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction, EntitySchemaIndex entitySchemaIndex)
Parameters
Declaration
protected virtual EntitySchemaAction AddEntitySchemaRenamingActions(DBMetaActionCollection actions, EntitySchema entitySchema, string entitySchemaName)
Parameters
Returns
Declaration
public abstract void AddEntitySchemaSavingActions(DBMetaActionCollection actions, EntitySchema entitySchema, bool saveAdditionalSchemas = true)
Parameters
Declaration
protected virtual ForeignKeyAction AddForeignKeyCreatingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
protected void AddForeignKeyDeletingAction(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected void AddForeignKeyDeletingAction(DBMetaActionCollection actions, EntitySchema entitySchema, string entitySchemaName, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Declaration
protected void AddForeignKeyDeletingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected void AddForeignKeyDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, string entitySchemaName, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Declaration
public void AddForeignKeyDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Declaration
protected void AddForeignKeyEditingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
protected virtual ForeignKeyAction AddForeignKeyRenamingActions(DBMetaActionCollection actions, ColumnAction columnAction, string foreignKeyName)
Parameters
Returns
Declaration
protected void AddForeignKeySavingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
protected void AddImageLookupTriggersCreatingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn column)
Parameters
Declaration
protected void AddImageLookupTriggersDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn column)
Parameters
AddIndexCreatingActions(DBMetaActionCollection, EntitySchema, EntitySchemaIndex, Boolean)
Declaration
protected virtual IndexAction AddIndexCreatingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaIndex entitySchemaIndex, bool isColumnIndex)
Parameters
Returns
AddIndexDeletingActions(DBMetaActionCollection, ColumnAction, EntitySchemaIndex)
Declaration
protected IndexAction AddIndexDeletingActions(DBMetaActionCollection actions, ColumnAction columnAction, EntitySchemaIndex entitySchemaIndex)
Parameters
Returns
AddIndexDeletingActions(DBMetaActionCollection, EntitySchemaAction, EntitySchemaIndex)
Declaration
protected void AddIndexDeletingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction, EntitySchemaIndex entitySchemaIndex)
Parameters
Declaration
protected void AddIndexesDeletingActions(DBMetaActionCollection actions, EntitySchemaAction entitySchemaAction)
Parameters
Declaration
protected abstract void AddLookupColumnModificationActions(DBMetaActionCollection actions, IDataReader dataReader, ModifyLookupColumnDirectionType directionType, EntitySchemaColumn sourceColumn, ColumnAction columnAction, bool isAddNewRecords)
Parameters
AddLookupToTextColumnModificationBranch(DBMetaActionCollection, IDataReader, EntitySchemaColumn, ColumnAction)
Declaration
protected void AddLookupToTextColumnModificationBranch(DBMetaActionCollection actions, IDataReader dataReader, EntitySchemaColumn sourceColumn, ColumnAction columnAction)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, ColumnAction action)
Parameters
Declaration
protected virtual void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, ColumnAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, DefValueAction action)
Parameters
Declaration
protected virtual void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, DefValueAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, EntitySchemaAction action)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, ForeignKeyAction action)
Parameters
Declaration
protected virtual void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, ForeignKeyAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, IndexAction action)
Parameters
Declaration
protected virtual void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, IndexAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, PrimaryKeyAction action)
Parameters
Declaration
protected virtual void AddMetaPropertyGroupCreatingActions(DBMetaActionCollection actions, PrimaryKeyAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected abstract void AddMetaPropertyGroupSavingActions(DBMetaActionCollection actions, EntitySchemaAction action, DBMetaPropertyCollection existingProperties)
Parameters
Declaration
protected void AddNotNullConstraintEditingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
protected abstract void AddNotNullValidateChain(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Declaration
protected virtual PrimaryKeyAction AddPrimaryKeyCreatingActions(DBMetaActionCollection actions, EntitySchema entitySchema, EntitySchemaColumn primaryColumn)
Parameters
Returns
Declaration
protected void AddPrimaryKeyDeletingActions(DBMetaActionCollection actions, EntitySchema entitySchema, string entitySchemaName)
Parameters
Declaration
protected abstract void AddPrimaryKeyEditingActions(DBMetaActionCollection actions, IDataReader dataReader, ColumnAction columnAction)
Parameters
Declaration
protected virtual PrimaryKeyAction AddPrimaryKeyRenamingActions(DBMetaActionCollection actions, ColumnAction columnAction, string primaryKeyName)
Parameters
Returns
Declaration
public void AddSysSettingsAddTriggerActions(DBMetaActionCollection actions, SysSettings sysSettings)
Parameters
AddTextToLookupColumnModificationBranch(DBMetaActionCollection, IDataReader, EntitySchemaColumn, ColumnAction)
Declaration
protected void AddTextToLookupColumnModificationBranch(DBMetaActionCollection actions, IDataReader dataReader, EntitySchemaColumn sourceColumn, ColumnAction columnAction)
Parameters
Declaration
protected void AddUniqueDataValidateSavingActions(DBMetaActionCollection actions, ColumnAction columnAction)
Parameters
Declaration
protected void AddUniqueDataValidateSavingActions(DBMetaActionCollection actions, IndexAction indexAction)
Parameters
Declaration
protected void AddUniqueIndexExistWarningMessage(DBMetaAction action)
Parameters
Applies the db cast options.
Declaration
public virtual int ApplyTypesCastOptions()
Returns
Type |
Description |
System.Int32 |
|
BuildColumnCaptions(StringBuilder, ICollection<EntitySchemaColumn>)
Declaration
public void BuildColumnCaptions(StringBuilder sb, ICollection<EntitySchemaColumn> columns)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Collections.Generic.ICollection<EntitySchemaColumn> |
columns |
|
BuildColumnShortCaptions(StringBuilder, ICollection<EntitySchemaColumn>)
Declaration
public void BuildColumnShortCaptions(StringBuilder sb, ICollection<EntitySchemaColumn> columns)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Collections.Generic.ICollection<EntitySchemaColumn> |
columns |
|
Declaration
public bool CheckActions(DBMetaActionCollection actions)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected bool CheckIfDataWillBeTruncated(string entitySchemaName, string columnName, DataValueType dbDataValueType, DataValueType dataValueType)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
DataValueType |
dbDataValueType |
|
DataValueType |
dataValueType |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected static void CheckIsArgumentNull(object value, string name)
Parameters
Type |
Name |
Description |
System.Object |
value |
|
System.String |
name |
|
Declaration
protected void CheckIsArgumentNullOrEmpty(string value, string name)
Parameters
Type |
Name |
Description |
System.String |
value |
|
System.String |
name |
|
Declaration
public bool CheckObject(EntitySchema entitySchema)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool CheckObject(EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
|
CheckObject(EntitySchemaIndex)
Declaration
public bool CheckObject(EntitySchemaIndex entitySchemaIndex)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected EntitySchemaColumn CreateColumn(IDataReader dataReader, DataValueType dataValueType, DBMetaPropertyCollection existingProperties, ColumnAction columnAction)
Parameters
Returns
Declaration
protected EntitySchemaColumn CreateColumn(string entitySchemaName, string columnName, EntitySchema entitySchema = null)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
EntitySchema |
entitySchema |
|
Returns
Declaration
public ColumnAction CreateColumnAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public ColumnAction CreateColumnAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Returns
Declaration
public ColumnAction CreateColumnAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public ColumnAction CreateColumnAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Returns
Declaration
public abstract EntitySchemaIndex CreateColumnIndex(ColumnAction columnAction)
Parameters
Returns
Declaration
protected ICollection<EntitySchemaIndex> CreateColumnIndexes(ColumnAction columnAction)
Parameters
Returns
Declaration
public ValidateAction CreateDanglingReferenceValidateAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
protected GroupAction CreateDanglingReferenceValidateGroupAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public abstract DataValueType CreateDBDataValueType(IDataReader dataReader)
Parameters
Type |
Name |
Description |
System.Data.IDataReader |
dataReader |
|
Returns
Declaration
public virtual DefValueAction CreateDefValueAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName = null, object value = null)
Parameters
Returns
Declaration
public DefValueAction CreateDefValueAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName = null, object value = null)
Parameters
Returns
Declaration
public EntitySchemaAction CreateEntitySchemaAction(ActionModifyType actionModifyType, EntitySchema entitySchema)
Parameters
Returns
Declaration
public EntitySchemaAction CreateEntitySchemaAction(ActionModifyType actionModifyType, EntitySchema entitySchema, string entitySchemaName)
Parameters
Returns
Declaration
public EntitySchemaAction CreateEntitySchemaAction(EntitySchema entitySchema)
Parameters
Returns
Declaration
public EntitySchemaAction CreateEntitySchemaAction(EntitySchema entitySchema, string entitySchemaName)
Parameters
Type |
Name |
Description |
EntitySchema |
entitySchema |
|
System.String |
entitySchemaName |
|
Returns
CreateEntitySchemaIndex(IndexAction)
Declaration
public abstract EntitySchemaIndex CreateEntitySchemaIndex(IndexAction indexAction)
Parameters
Returns
CreateEntitySchemaIndexes(String, EntitySchema)
Declaration
protected abstract ICollection<EntitySchemaIndex> CreateEntitySchemaIndexes(string entitySchemaName, EntitySchema entitySchema = null)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
EntitySchema |
entitySchema |
|
Returns
Declaration
public ForeignKeyAction CreateForeignKeyAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName = null)
Parameters
Returns
Declaration
public ForeignKeyAction CreateForeignKeyAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName = null)
Parameters
Returns
Declaration
public ForeignKeyAction CreateForeignKeyAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, EntitySchema referenceEntitySchema)
Parameters
Returns
Declaration
public GroupAction CreateGroupAction(EntitySchema entitySchema)
Parameters
Returns
Declaration
public GroupAction CreateGroupAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
CreateIndexAction(ActionModifyType, EntitySchema, EntitySchemaIndex)
Declaration
public IndexAction CreateIndexAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaIndex entitySchemaIndex)
Parameters
Returns
CreateIndexAction(ActionModifyType, EntitySchema, EntitySchemaIndex, String)
Declaration
public IndexAction CreateIndexAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaIndex entitySchemaIndex, string indexName)
Parameters
Returns
CreateIndexAction(EntitySchema, EntitySchemaIndex)
Declaration
public IndexAction CreateIndexAction(EntitySchema entitySchema, EntitySchemaIndex entitySchemaIndex)
Parameters
Returns
CreateIndexAction(EntitySchema, EntitySchemaIndex, String)
Declaration
public IndexAction CreateIndexAction(EntitySchema entitySchema, EntitySchemaIndex entitySchemaIndex, string indexName)
Parameters
Returns
Declaration
public ModifyColumnTypeValidateAction CreateModifyColumnTypeValidateAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
public NotNullColumnAction CreateNotNullColumnAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
public NotNullColumnAction CreateNotNullColumnAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public ValidateAction CreateNotNullColumnValidateAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
protected GroupAction CreateNotNullColumnValidateGroupAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(ActionModifyType actionModifyType, EntitySchema entitySchema)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(ActionModifyType actionModifyType, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(EntitySchema entitySchema)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public PrimaryKeyAction CreatePrimaryKeyAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string constraintName)
Parameters
Returns
Declaration
public SetColumnValueAction CreateSetColumnValueAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
protected EntitySchemaColumn CreateTemporaryColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public GroupAction CreateTemporaryGroupAction()
Returns
Declaration
public TriggerAction CreateTriggerAction(ActionModifyType actionModifyType, TriggerType triggerType, EntitySchema entitySchema)
Parameters
Returns
Declaration
public ValidateAction CreateUniqueDataValidateAction(EntitySchema entitySchema, IList<EntitySchemaColumn> entitySchemaColumns)
Parameters
Returns
Declaration
public ValidateAction CreateUniqueDataValidateAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
protected ValidateAction CreateValidateAction(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Declaration
public void ExecuteActions(DBMetaActionCollection actions)
Parameters
Declaration
protected void ExecuteWithDBElementCache(string schemaName, Action action)
Parameters
Type |
Name |
Description |
System.String |
schemaName |
|
System.Action |
action |
|
Declaration
public IDataReader GetColumnDataReader(DBExecutor dbExecutor, string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
public abstract IDataReader GetColumnForeignKeyDataReader(DBExecutor dbExecutor, string entitySchemaName, string foreignKeyName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
foreignKeyName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
protected IDataReader GetColumnIndexesDataReader(DBExecutor dbExecutor, string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
public IDataReader GetColumnsDataReader(DBExecutor dbExecutor, string entitySchemaName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
protected IParametrizedQuery GetDanglingReferenceValidateQuery(string childSchemaName, string childColumnName, string parentSchemaName, string parentColumnName, DataValueType dataValueType)
Parameters
Type |
Name |
Description |
System.String |
childSchemaName |
|
System.String |
childColumnName |
|
System.String |
parentSchemaName |
|
System.String |
parentColumnName |
|
DataValueType |
dataValueType |
|
Returns
Returns number of rows in table.
Declaration
public virtual int GetDBRowsCount(string entitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
Table name.
|
Returns
Type |
Description |
System.Int32 |
Numbers of rows.
|
Declaration
public string GetForeignKeyColumnName(string entitySchemaName, string foreignKeyName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
foreignKeyName |
|
Returns
Type |
Description |
System.String |
|
Declaration
public abstract IDataReader GetForeignKeyDataReader(DBExecutor dbExecutor, string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Returns foreign keys data reader.
Declaration
public abstract IDataReader GetForeignKeysDataReader(DBExecutor dbExecutor, string entitySchemaName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
Instance of DBExecutor. Provides DB query execution.
|
System.String |
entitySchemaName |
Schema name to get foreign keys for.
|
Returns
Type |
Description |
System.Data.IDataReader |
System.Data.IDataReader.
|
GetGroupActionTypeText(DBMetaAction)
Declaration
public string GetGroupActionTypeText(DBMetaAction groupItem)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
public string GetGroupResourceItemName(GroupAction groupAction, ActionType actionType)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
public string GetGroupShortResourceItemName(DBMetaAction groupAction, ActionType actionType)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
public abstract IDataReader GetIndexDataReader(DBExecutor dbExecutor, string entitySchemaName, string indexName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
indexName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
protected IDataReader GetIndexesDataReader(DBExecutor dbExecutor, string entitySchemaName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
GetIsActionExist(DBMetaActionCollection, ActionModifyType, EntitySchemaIndex)
Declaration
protected bool GetIsActionExist(DBMetaActionCollection actions, ActionModifyType actionModifyType, EntitySchemaIndex entitySchemaIndex)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsColumnExist(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
public virtual bool GetIsDataValueTypeEquals(DataValueType dataValueType, DataValueType columnDataValueType)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsDBDataExist(string entitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsDBDataExist(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Boolean |
|
Determines if column value is required on database level.
Declaration
public abstract bool GetIsDBLevelRequirementTypeColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
Value that indicates whether column value is required on database level.
|
Determines if column is of type that requires default value.
Declaration
public abstract bool GetIsDefValueTypeColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
Value that indicates whether column is of type that requires default value.
|
Declaration
public bool GetIsEntitySchemaExist(string entitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.Boolean |
|
Determines whether foreign key is cascade.
Declaration
public abstract bool GetIsForeignKeyCascade(IDataReader dataReader)
Parameters
Type |
Name |
Description |
System.Data.IDataReader |
dataReader |
Instance of Terrasoft.Core.DataReader to read property.
|
Returns
Type |
Description |
System.Boolean |
true if foreign key is cascade. Otherwise returns false .
|
Declaration
protected virtual bool GetIsForeignKeyEqual(IDataReader dataReader, EntitySchemaColumn entitySchemaColumn)
Parameters
Type |
Name |
Description |
System.Data.IDataReader |
dataReader |
|
EntitySchemaColumn |
entitySchemaColumn |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsForeignKeyExist(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Boolean |
|
GetIsIndexEqual(EntitySchemaIndex, EntitySchemaIndex)
Declaration
public virtual bool GetIsIndexEqual(EntitySchemaIndex indexA, EntitySchemaIndex indexB)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsIndexExist(string entitySchemaName, string indexName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
indexName |
|
Returns
Type |
Description |
System.Boolean |
|
Determines whether index is unique.
Declaration
public abstract bool GetIsIndexUnique(IDataReader dataReader)
Parameters
Type |
Name |
Description |
System.Data.IDataReader |
dataReader |
Instance of Terrasoft.Core.DataReader to read property.
|
Returns
Type |
Description |
System.Boolean |
true if index is unique. Otherwise returns false .
|
Declaration
public abstract bool GetIsNotNullColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected bool GetIsPrimaryColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
|
GetIsTextColumnContainGuid(String, String)
Declaration
protected bool GetIsTextColumnContainGuid(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
public bool GetIsTriggerExist(string entitySchemaName, string triggerName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
triggerName |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected bool GetIsUniqueIndexContainColumn(EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
protected IParametrizedQuery GetModifyColumnTypeQuery(string entitySchemaName, EntitySchemaColumn sourceColumn, EntitySchemaColumn destinationColumn)
Parameters
Returns
Declaration
protected IParametrizedQuery GetModifyColumnTypeValidateQuery(string entitySchemaName, EntitySchemaColumn sourceColumn, EntitySchemaColumn destinationColumn)
Parameters
Returns
Declaration
protected IParametrizedQuery GetModifyLookupColumnTypeQuery(ModifyLookupColumnDirectionType directionType, string entitySchemaName, EntitySchemaColumn sourceColumn, EntitySchemaColumn destinationColumn, bool isAddNewRecords)
Parameters
Returns
Declaration
protected virtual IParametrizedQuery GetNotNullColumnValidateQuery(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Declaration
public abstract bool GetNotNullDataReaderValue(IDataReader dataReader)
Parameters
Type |
Name |
Description |
System.Data.IDataReader |
dataReader |
|
Returns
Type |
Description |
System.Boolean |
|
Declaration
public virtual string GetPrimaryColumnName(string entitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.String |
|
Declaration
protected string GetPrimaryKeyNameFromDB(string entitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
Returns
Type |
Description |
System.String |
|
GetTriggerBody(String, String)
Declaration
public string GetTriggerBody(string entitySchemaName, string triggerName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
triggerName |
|
Returns
Type |
Description |
System.String |
|
Declaration
public virtual IDataReader GetTriggerDataReader(DBExecutor dbExecutor, string entitySchemaName, string triggerName)
Parameters
Type |
Name |
Description |
DBExecutor |
dbExecutor |
|
System.String |
entitySchemaName |
|
System.String |
triggerName |
|
Returns
Type |
Description |
System.Data.IDataReader |
|
Declaration
public TResult GetTypedValue<TResult>(object value)
Parameters
Type |
Name |
Description |
System.Object |
value |
|
Returns
Type Parameters
Declaration
protected IParametrizedQuery GetUniqueDataValidateQuery(string entitySchemaName, params string[] columnNames)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String[] |
columnNames |
|
Returns
Declaration
public virtual void Initialize(UserConnection userConnection)
Parameters
Declaration
public virtual void InitializeColumnQuery(ColumnAction action)
Parameters
Declaration
public virtual void InitializeDefValueQuery(DefValueAction action)
Parameters
Declaration
public virtual void InitializeEntitySchemaQuery(EntitySchemaAction action)
Parameters
Declaration
public virtual void InitializeForeignKeyQuery(ForeignKeyAction action)
Parameters
Declaration
public virtual void InitializeIndexQuery(IndexAction action)
Parameters
Declaration
protected virtual void InitializeModifyTypeValidateQueryParameters(QueryParameterCollection parameters, string entitySchemaName, string columnName, string dataValueTypeName)
Parameters
Type |
Name |
Description |
QueryParameterCollection |
parameters |
|
System.String |
entitySchemaName |
|
System.String |
columnName |
|
System.String |
dataValueTypeName |
|
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
public void InitializeNotNullColumnQuery(NotNullColumnAction action)
Parameters
Declaration
public void InitializeNullableColumnQuery(ColumnAction action)
Parameters
Declaration
public virtual void InitializePrimaryKeyQuery(PrimaryKeyAction action)
Parameters
Declaration
public void InitializeSetColumnValueQuery(SetColumnValueAction action)
Parameters
Declaration
public virtual void InitializeTriggerQuery(TriggerAction action)
Parameters
Declaration
protected void OnSchemaDBActionMessage(string schemaName, string message)
Parameters
Type |
Name |
Description |
System.String |
schemaName |
|
System.String |
message |
|
Declaration
public static void RaiseUnsupportedActionModifyTypeException(ActionModifyType actionModifyType)
Parameters
Events
Declaration
public event EventHandler<SchemaDBActionMessageEventArgs> SchemaDBActionMessage
Event Type
Extension Methods