Class DBEngine
Provides methods for queries building.
Inheritance
System.Object
DBEngine
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
Syntax
public abstract class DBEngine : IDbStructureEngine, IDbDataValueTypeEngine, IDbDefaultValueEngine, IDbDataValueTypeComparer
Fields
_anyStringPatternSymbol
Declaration
protected string _anyStringPatternSymbol
Field Value
Type |
Description |
System.String |
|
_bitwiseAnd
Declaration
protected string _bitwiseAnd
Field Value
Type |
Description |
System.String |
|
_bitwiseNot
Declaration
protected string _bitwiseNot
Field Value
Type |
Description |
System.String |
|
_bitwiseOr
Declaration
protected string _bitwiseOr
Field Value
Type |
Description |
System.String |
|
_bitwiseXor
Declaration
protected string _bitwiseXor
Field Value
Type |
Description |
System.String |
|
_builderConcatOperation
Declaration
protected string _builderConcatOperation
Field Value
Type |
Description |
System.String |
|
_canDeleteHierarchyCascaded
Declaration
protected bool _canDeleteHierarchyCascaded
Field Value
Type |
Description |
System.Boolean |
|
_concatOperation
Declaration
protected string _concatOperation
Field Value
Type |
Description |
System.String |
|
_coreUtilitiesPackageName
Declaration
protected string _coreUtilitiesPackageName
Field Value
Type |
Description |
System.String |
|
_endDelimiter
Declaration
protected string _endDelimiter
Field Value
Type |
Description |
System.String |
|
_forceSeekHint
Declaration
protected string _forceSeekHint
Field Value
Type |
Description |
System.String |
|
_isEmptyStringEqualNull
Declaration
protected bool _isEmptyStringEqualNull
Field Value
Type |
Description |
System.Boolean |
|
_lengthFunctionName
Declaration
protected string _lengthFunctionName
Field Value
Type |
Description |
System.String |
|
_parameterMarker
Declaration
protected string _parameterMarker
Field Value
Type |
Description |
System.String |
|
_rowLockHint
Declaration
protected string _rowLockHint
Field Value
Type |
Description |
System.String |
|
_startDelimiter
Declaration
protected string _startDelimiter
Field Value
Type |
Description |
System.String |
|
_subStrFunctionName
Declaration
protected string _subStrFunctionName
Field Value
Type |
Description |
System.String |
|
_systemPackageName
Declaration
protected string _systemPackageName
Field Value
Type |
Description |
System.String |
|
_topStatement
Declaration
protected string _topStatement
Field Value
Type |
Description |
System.String |
|
_triggerActions
Declaration
protected Dictionary<TriggerType, string> _triggerActions
Field Value
Type |
Description |
System.Collections.Generic.Dictionary<TriggerType, System.String> |
|
_unicodeDataPrefix
Declaration
protected string _unicodeDataPrefix
Field Value
Type |
Description |
System.String |
|
_useOrderNullsPosition
Declaration
protected bool _useOrderNullsPosition
Field Value
Type |
Description |
System.Boolean |
|
_useUpperExpressions
Declaration
protected bool _useUpperExpressions
Field Value
Type |
Description |
System.Boolean |
|
DanglingChildSchemaAlias
Declaration
public const string DanglingChildSchemaAlias = "ChildSchema"
Field Value
Type |
Description |
System.String |
|
DanglingReferenceSchemaAlias
Declaration
public const string DanglingReferenceSchemaAlias = "ReferencedSchema"
Field Value
Type |
Description |
System.String |
|
Declaration
protected const string EndCommentKeyword = "=--"
Field Value
Type |
Description |
System.String |
|
Declaration
protected const string EndMultilineCommentKeyword = "*/"
Field Value
Type |
Description |
System.String |
|
IntegrityCheckDefinitionKeyword
Declaration
protected const string IntegrityCheckDefinitionKeyword = "INTEGRITY CHECK"
Field Value
Type |
Description |
System.String |
|
NewLineKeyword
Declaration
protected const string NewLineKeyword = "\n"
Field Value
Type |
Description |
System.String |
|
Declaration
protected const string StartCommentKeyword = "--="
Field Value
Type |
Description |
System.String |
|
Declaration
protected const string StartMultilineCommentKeyword = "/*"
Field Value
Type |
Description |
System.String |
|
SysImageSchemaName
Declaration
protected const string SysImageSchemaName = "SysImage"
Field Value
Type |
Description |
System.String |
|
SysImageSchemaPrimaryColumnName
Declaration
protected const string SysImageSchemaPrimaryColumnName = "Id"
Field Value
Type |
Description |
System.String |
|
TabKeyword
Declaration
protected const string TabKeyword = "\t"
Field Value
Type |
Description |
System.String |
|
TriggerBeginDefinitionKeyword
Declaration
protected const string TriggerBeginDefinitionKeyword = "--=BEGIN=--"
Field Value
Type |
Description |
System.String |
|
TriggerEndBodyDefinitionKeyword
Declaration
protected const string TriggerEndBodyDefinitionKeyword = "--=END BODY=--"
Field Value
Type |
Description |
System.String |
|
TriggerStartBodyDefinitionKeyword
Declaration
protected const string TriggerStartBodyDefinitionKeyword = "--=START BODY=--"
Field Value
Type |
Description |
System.String |
|
Properties
AllowsMars
Represents whether the database allows multiple active result sets.
Declaration
public abstract bool AllowsMars { get; }
Property Value
Type |
Description |
System.Boolean |
|
AnyStringPatternSymbol
Declaration
public string AnyStringPatternSymbol { get; }
Property Value
Type |
Description |
System.String |
|
CanDeleteHierarchyCascaded
Declaration
public bool CanDeleteHierarchyCascaded { get; }
Property Value
Type |
Description |
System.Boolean |
|
CanOrderByMaxSizeTextColumn
Declaration
[Obsolete("7.13.2 | Use NeedCastOrderedTextColumn(TextDataValueType orderedColumnDataValueType) instead")]
public abstract bool CanOrderByMaxSizeTextColumn { get; }
Property Value
Type |
Description |
System.Boolean |
|
CharactersMaximumLengthAlias
Declaration
public string CharactersMaximumLengthAlias { get; }
Property Value
Type |
Description |
System.String |
|
ColumnNameAlias
Declaration
public string ColumnNameAlias { get; }
Property Value
Type |
Description |
System.String |
|
ConcatOperation
Declaration
public string ConcatOperation { get; }
Property Value
Type |
Description |
System.String |
|
ConstraintNameAlias
Declaration
public string ConstraintNameAlias { get; }
Property Value
Type |
Description |
System.String |
|
ConstraintTypeAlias
Declaration
public string ConstraintTypeAlias { get; }
Property Value
Type |
Description |
System.String |
|
CoreUtilitiesPackageName
Declaration
public string CoreUtilitiesPackageName { get; }
Property Value
Type |
Description |
System.String |
|
CurrentSchemaName
Declaration
public string CurrentSchemaName { get; }
Property Value
Type |
Description |
System.String |
|
DataDefaultValueAlias
Declaration
public string DataDefaultValueAlias { get; }
Property Value
Type |
Description |
System.String |
|
DataTypeAlias
Declaration
public string DataTypeAlias { get; }
Property Value
Type |
Description |
System.String |
|
DBEngineType
Declaration
public abstract DBEngineType DBEngineType { get; }
Property Value
Type |
Description |
DBEngineType |
|
Declaration
protected DBMetaScript DBMetaScript { get; }
Property Value
EndDelimiter
Declaration
public string EndDelimiter { get; }
Property Value
Type |
Description |
System.String |
|
IndexNameAlias
Declaration
public string IndexNameAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsCascadeKeyAlias
Declaration
public string IsCascadeKeyAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsCaseInsensitive
Declaration
public bool IsCaseInsensitive { get; set; }
Property Value
Type |
Description |
System.Boolean |
|
IsCharLengthSemanticsAlias
Declaration
public virtual string IsCharLengthSemanticsAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsClusteredIndexAlias
Declaration
public virtual string IsClusteredIndexAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsConstraintClusteredAlias
Declaration
public virtual string IsConstraintClusteredAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsDescendingIndexAlias
Declaration
public string IsDescendingIndexAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsEmptyStringEqualNull
Declaration
public bool IsEmptyStringEqualNull { get; }
Property Value
Type |
Description |
System.Boolean |
|
IsNullableColumnAlias
Declaration
public string IsNullableColumnAlias { get; }
Property Value
Type |
Description |
System.String |
|
IsUniqueIndexAlias
Declaration
public string IsUniqueIndexAlias { get; }
Property Value
Type |
Description |
System.String |
|
NeedWrapInUpperFunction
Declaration
[Obsolete("7.13.0 | Use NeedWrapFilterTextInUpperFunction(EntitySchemaQueryFilter filter) instead")]
public abstract bool NeedWrapInUpperFunction { get; }
Property Value
Type |
Description |
System.Boolean |
|
NumericPrecisionAlias
Declaration
public string NumericPrecisionAlias { get; }
Property Value
Type |
Description |
System.String |
|
NumericScaleAlias
Declaration
public string NumericScaleAlias { get; }
Property Value
Type |
Description |
System.String |
|
ParameterMarker
Declaration
public string ParameterMarker { get; }
Property Value
Type |
Description |
System.String |
|
ParentColumnNameAlias
Declaration
public string ParentColumnNameAlias { get; }
Property Value
Type |
Description |
System.String |
|
ReferencedTableNameAlias
Declaration
public string ReferencedTableNameAlias { get; }
Property Value
Type |
Description |
System.String |
|
StartDelimiter
Declaration
public string StartDelimiter { get; }
Property Value
Type |
Description |
System.String |
|
SystemPackageName
Declaration
public string SystemPackageName { get; }
Property Value
Type |
Description |
System.String |
|
TopStatement
Declaration
public string TopStatement { get; }
Property Value
Type |
Description |
System.String |
|
UnicodeDataPrefix
Declaration
public string UnicodeDataPrefix { get; }
Property Value
Type |
Description |
System.String |
|
UserConnection
Declaration
public UserConnection UserConnection { get; }
Property Value
Methods
AddAdditionalSqlInfo(StringBuilder)
Adds an additional information about sql query.
Declaration
protected virtual void AddAdditionalSqlInfo(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
The instance of the System.Text.StringBuilder class, which helps to generate sql query.
|
AppendLikeKeyword(StringBuilder)
Appends LIKE
SQL keyword.
Declaration
protected virtual void AppendLikeKeyword(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Instance of System.Text.StringBuilder to append keyword to.
|
BuildAdditionalConditionSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildAdditionalConditionSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildAfterColumnsSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildAfterColumnsSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildAfterConditionSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildAfterConditionSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildAfterQuerySqlText(StringBuilder, Select)
Declaration
protected virtual void BuildAfterQuerySqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildBeforeColumnsSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildBeforeColumnsSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildBeforeConditionSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildBeforeConditionSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildBinaryDataValueTypeSqlText(StringBuilder, BinaryDataValueType)
Declaration
public abstract void BuildBinaryDataValueTypeSqlText(StringBuilder sb, BinaryDataValueType binaryDataValueType)
Parameters
BuildBooleanDataValueTypeSqlText(StringBuilder, BooleanDataValueType)
Declaration
public abstract void BuildBooleanDataValueTypeSqlText(StringBuilder sb, BooleanDataValueType booleanDataValueType)
Parameters
BuildBooleanValueSqlText(StringBuilder, Boolean)
Declaration
protected abstract void BuildBooleanValueSqlText(StringBuilder sb, bool value)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Boolean |
value |
|
BuildCastToTimeSqlText(StringBuilder, Action<StringBuilder>)
Declaration
protected virtual void BuildCastToTimeSqlText(StringBuilder sb, Action<StringBuilder> innerExpressionBuilder)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Action<System.Text.StringBuilder> |
innerExpressionBuilder |
|
BuildConditionSqlText(StringBuilder, QueryCondition, String)
Declaration
protected void BuildConditionSqlText(StringBuilder sb, QueryCondition condition, string leftExpressionSufix = null)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
QueryCondition |
condition |
|
System.String |
leftExpressionSufix |
|
BuildConditionSqlText(StringBuilder, UpdateSelect)
Declaration
protected virtual void BuildConditionSqlText(StringBuilder sb, UpdateSelect query)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
UpdateSelect |
query |
|
BuildConstantGuidValueSqlText(StringBuilder, Guid)
Declaration
protected virtual void BuildConstantGuidValueSqlText(StringBuilder sb, Guid value)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Guid |
value |
|
BuildCreateColumnDefinitionSqlText(StringBuilder, EntitySchema, String, EntitySchemaColumn, String)
Declaration
protected void BuildCreateColumnDefinitionSqlText(StringBuilder sb, EntitySchema entitySchema, string entitySchemaName, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
EntitySchema |
entitySchema |
|
System.String |
entitySchemaName |
|
EntitySchemaColumn |
entitySchemaColumn |
|
System.String |
columnName |
|
BuildCreateColumnsSqlText(StringBuilder, EntitySchema, ICollection<EntitySchemaColumn>)
Declaration
protected void BuildCreateColumnsSqlText(StringBuilder sb, EntitySchema entitySchema, ICollection<EntitySchemaColumn> columns)
Parameters
BuildCreateDefValueSqlText(StringBuilder, DefValueAction)
Declaration
public virtual void BuildCreateDefValueSqlText(StringBuilder sb, DefValueAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
DefValueAction |
action |
|
BuildCreateDefValueSqlText(StringBuilder, EntitySchema, EntitySchemaColumn)
Declaration
public abstract void BuildCreateDefValueSqlText(StringBuilder sb, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
BuildCreateEntitySchemaColumnSqlText(StringBuilder, ColumnAction)
Declaration
public virtual void BuildCreateEntitySchemaColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildCreateEntitySchemaSqlText(StringBuilder, EntitySchema)
Declaration
public void BuildCreateEntitySchemaSqlText(StringBuilder sb, EntitySchema entitySchema)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
EntitySchema |
entitySchema |
|
BuildCreateForeignKeySqlText(StringBuilder, ForeignKeyAction)
Declaration
public void BuildCreateForeignKeySqlText(StringBuilder sb, ForeignKeyAction action)
Parameters
BuildCreateIndexSqlText(StringBuilder, IndexAction)
Declaration
public virtual void BuildCreateIndexSqlText(StringBuilder sb, IndexAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
IndexAction |
action |
|
BuildCreateNullableColumnDefinitionSqlText(StringBuilder, EntitySchema, EntitySchemaColumn)
Declaration
protected void BuildCreateNullableColumnDefinitionSqlText(StringBuilder sb, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
BuildCreateNullableColumnSqlText(StringBuilder, ColumnAction)
Declaration
public virtual void BuildCreateNullableColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildCreatePrimaryKeySqlText(StringBuilder, PrimaryKeyAction)
Declaration
public virtual void BuildCreatePrimaryKeySqlText(StringBuilder sb, PrimaryKeyAction action)
Parameters
BuildCreateSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for droping sequence from DB. sb
.
Declaration
public virtual void BuildCreateSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for sql text string.
|
Sequence |
sequence |
Sequence object.
|
BuildCreateTriggerSqlText(StringBuilder, TriggerAction)
Declaration
public virtual void BuildCreateTriggerSqlText(StringBuilder sb, TriggerAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
TriggerAction |
action |
|
BuildCreateWeakNullableSqlText(StringBuilder, EntitySchema, EntitySchemaColumn, String)
Declaration
public abstract void BuildCreateWeakNullableSqlText(StringBuilder sb, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
BuildCurrentValueSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for getting current value for sequence. sb
.
Declaration
public abstract void BuildCurrentValueSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
BuildDataValueTypeSqlText(StringBuilder, EntitySchemaColumn)
Declaration
public void BuildDataValueTypeSqlText(StringBuilder sb, EntitySchemaColumn entitySchemaColumn)
Parameters
BuildDateTimeColumnValueToLocalTimeSqlText(StringBuilder, String, QueryColumnExpression)
Declaration
protected virtual void BuildDateTimeColumnValueToLocalTimeSqlText(StringBuilder sb, string timeZoneName, QueryColumnExpression expression)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
timeZoneName |
|
QueryColumnExpression |
expression |
|
BuildDateTimeColumnValueToLocalTimeSqlText(StringBuilder, TimeSpan, QueryColumnExpression)
Declaration
protected virtual void BuildDateTimeColumnValueToLocalTimeSqlText(StringBuilder sb, TimeSpan offset, QueryColumnExpression expression)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.TimeSpan |
offset |
|
QueryColumnExpression |
expression |
|
BuildDateTimeDataValueTypeSqlText(StringBuilder, DateTimeDataValueType)
Declaration
public abstract void BuildDateTimeDataValueTypeSqlText(StringBuilder sb, DateTimeDataValueType dateTimeDataValueType)
Parameters
BuildDateTimeValueSqlText(StringBuilder, DateTime)
Declaration
protected abstract void BuildDateTimeValueSqlText(StringBuilder sb, DateTime dateTimeValue)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.DateTime |
dateTimeValue |
|
BuildDateValueSqlText(StringBuilder, DateTime)
Declaration
protected abstract void BuildDateValueSqlText(StringBuilder sb, DateTime dateTimeValue)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.DateTime |
dateTimeValue |
|
BuildDBObjectNameDataValueTypeSqlText(StringBuilder, DBObjectNameDataValueType)
Declaration
public abstract void BuildDBObjectNameDataValueTypeSqlText(StringBuilder sb, DBObjectNameDataValueType dbObjectNameDataValueType)
Parameters
BuildDeleteConstraintSqlText(StringBuilder, ConstraintAction)
Declaration
public virtual void BuildDeleteConstraintSqlText(StringBuilder sb, ConstraintAction action)
Parameters
BuildDeleteEntitySchemaColumnSqlText(StringBuilder, ColumnAction)
Declaration
public void BuildDeleteEntitySchemaColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildDeleteEntitySchemaNotNullConstraintSqlText(StringBuilder, ColumnAction)
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
public virtual void BuildDeleteEntitySchemaNotNullConstraintSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildDeleteEntitySchemaSqlText(StringBuilder, EntitySchema)
Declaration
public void BuildDeleteEntitySchemaSqlText(StringBuilder sb, EntitySchema entitySchema)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
EntitySchema |
entitySchema |
|
BuildDeleteIndexSqlText(StringBuilder, IndexAction)
Declaration
public virtual void BuildDeleteIndexSqlText(StringBuilder sb, IndexAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
IndexAction |
action |
|
BuildDeleteNotNullDefinitionSqlText(StringBuilder, String, EntitySchemaColumn, String)
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
protected void BuildDeleteNotNullDefinitionSqlText(StringBuilder sb, string entitySchemaName, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
entitySchemaName |
|
EntitySchemaColumn |
entitySchemaColumn |
|
System.String |
columnName |
|
BuildDeleteQuerySqlText(StringBuilder, Delete)
Declaration
protected void BuildDeleteQuerySqlText(StringBuilder sb, Delete deleteQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Delete |
deleteQuery |
|
BuildDeleteTriggerSqlText(StringBuilder, TriggerAction)
Declaration
public void BuildDeleteTriggerSqlText(StringBuilder sb, TriggerAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
TriggerAction |
action |
|
BuildDropConstraintSqlText(StringBuilder, ConstraintAction)
Declaration
protected void BuildDropConstraintSqlText(StringBuilder sb, ConstraintAction action)
Parameters
BuildDropSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for dropping sequence from DB. sb
.
Declaration
public abstract void BuildDropSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
BuildEditColumnDefinitionSqlText(StringBuilder, EntitySchema, EntitySchemaColumn)
Declaration
protected void BuildEditColumnDefinitionSqlText(StringBuilder sb, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
BuildEditColumnsSqlText(StringBuilder, EntitySchema, ICollection<EntitySchemaColumn>)
Declaration
protected virtual void BuildEditColumnsSqlText(StringBuilder sb, EntitySchema entitySchema, ICollection<EntitySchemaColumn> columns)
Parameters
BuildEditEntitySchemaColumnSqlText(StringBuilder, ColumnAction)
Declaration
public virtual void BuildEditEntitySchemaColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildEditEntitySchemaSqlText(StringBuilder, EntitySchemaAction)
Declaration
public virtual void BuildEditEntitySchemaSqlText(StringBuilder sb, EntitySchemaAction action)
Parameters
BuildEditIntegrityCheckModifyTriggerCheckModifyBody(StringBuilder, String, String)
Declaration
public abstract void BuildEditIntegrityCheckModifyTriggerCheckModifyBody(StringBuilder sb, string oldEntitySchemaName, string entitySchemaName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
oldEntitySchemaName |
|
System.String |
entitySchemaName |
|
BuildEditNullableColumnDefinitionSqlText(StringBuilder, ColumnAction)
Declaration
protected void BuildEditNullableColumnDefinitionSqlText(StringBuilder sb, ColumnAction columnAction)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
columnAction |
|
BuildEditNullableColumnSqlText(StringBuilder, String, String)
Declaration
[Obsolete("7.13.2 | Method is not in use and will be removed in upcoming releases")]
public virtual void BuildEditNullableColumnSqlText(StringBuilder sb, string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
entitySchemaName |
|
System.String |
columnName |
|
BuildEditNullableColumnSqlText(StringBuilder, ColumnAction)
Declaration
public virtual void BuildEditNullableColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildEditSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder, String, String, String, Guid)
Declaration
public void BuildEditSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder sb, string triggerName, string referenceSchemaName, string referenceSchemaPrimaryColumnName, Guid sysSettingsId)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
triggerName |
|
System.String |
referenceSchemaName |
|
System.String |
referenceSchemaPrimaryColumnName |
|
System.Guid |
sysSettingsId |
|
BuildEditSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder, String, Guid, SysSettingsReferenceSchemaCollection)
Declaration
public void BuildEditSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder sb, string triggerName, Guid id, SysSettingsReferenceSchemaCollection referenceSchemaList)
Parameters
BuildEditWeakNullableColumnDefinitionSqlText(StringBuilder, EntitySchema, EntitySchemaColumn, String)
Declaration
protected void BuildEditWeakNullableColumnDefinitionSqlText(StringBuilder sb, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
BuildExistSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for checking existence sequence in DB. sb
.
Declaration
public abstract void BuildExistSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
BuildFirstPageWithHierarchySelectSqlText(StringBuilder, Select, Select, PageableSelectOptions, HierarchicalSelectOptions)
Declaration
protected abstract void BuildFirstPageWithHierarchySelectSqlText(StringBuilder sb, Select mainSelect, Select select, PageableSelectOptions pageableOptions, HierarchicalSelectOptions hierarchicalOptions)
Parameters
BuildFloatDataValueTypeSqlText(StringBuilder, FloatDataValueType)
Declaration
public abstract void BuildFloatDataValueTypeSqlText(StringBuilder sb, FloatDataValueType floatDataValueType)
Parameters
BuildFloatValueSqlText(StringBuilder, Double)
Declaration
protected abstract void BuildFloatValueSqlText(StringBuilder sb, double doubleValue)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Double |
doubleValue |
|
BuildForceSeekHintSqlText(StringBuilder)
Builds ForceSeek table hint SQL text.
Declaration
public void BuildForceSeekHintSqlText(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for sql text string.
|
BuildGuidDataValueTypeSqlText(StringBuilder, GuidDataValueType)
Declaration
public abstract void BuildGuidDataValueTypeSqlText(StringBuilder sb, GuidDataValueType guidDataValueType)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
GuidDataValueType |
guidDataValueType |
|
BuildHierarchicalSelectSqlText(StringBuilder, Select, HierarchicalSelectOptions)
Declaration
protected abstract void BuildHierarchicalSelectSqlText(StringBuilder sb, Select select, HierarchicalSelectOptions options)
Parameters
BuildHintsBeforeColumnsSqlText(StringBuilder, HintCollection)
Declaration
protected virtual void BuildHintsBeforeColumnsSqlText(StringBuilder sb, HintCollection hints)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
HintCollection |
hints |
|
BuildIndexColumn(StringBuilder, EntitySchemaIndexColumn, IndexAction)
Declaration
protected virtual void BuildIndexColumn(StringBuilder sb, EntitySchemaIndexColumn column, IndexAction action)
Parameters
BuildIndexColumns(StringBuilder, IndexAction)
Declaration
protected void BuildIndexColumns(StringBuilder sb, IndexAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
IndexAction |
action |
|
BuildIndexHintSqlText(StringBuilder, IndexHint)
Declaration
public abstract void BuildIndexHintSqlText(StringBuilder sb, IndexHint indexSqlHint)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
IndexHint |
indexSqlHint |
|
BuildInsertColumnsBlock(StringBuilder, Insert)
Declaration
protected virtual void BuildInsertColumnsBlock(StringBuilder sb, Insert insertQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Insert |
insertQuery |
|
BuildInsertColumnValuesSqlText(StringBuilder, Insert)
Declaration
protected virtual void BuildInsertColumnValuesSqlText(StringBuilder sb, Insert insertQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Insert |
insertQuery |
|
Declaration
protected virtual void BuildInsertHeaderBlock(StringBuilder sb, Insert insertQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Insert |
insertQuery |
|
BuildInsertQuerySqlText(StringBuilder, Insert)
Declaration
protected virtual void BuildInsertQuerySqlText(StringBuilder sb, Insert insertQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Insert |
insertQuery |
|
BuildInsertQueryValuesSqlText(StringBuilder, ModifyQueryColumnValueCollection)
Declaration
protected virtual void BuildInsertQueryValuesSqlText(StringBuilder sb, ModifyQueryColumnValueCollection columnValues)
Parameters
BuildInsertSelectQuerySqlText(StringBuilder, InsertSelect)
Declaration
protected void BuildInsertSelectQuerySqlText(StringBuilder sb, InsertSelect insertSelectQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
InsertSelect |
insertSelectQuery |
|
BuildInsertValuesBlock(StringBuilder)
Declaration
protected virtual void BuildInsertValuesBlock(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
BuildIntegerDataValueTypeSqlText(StringBuilder, IntegerDataValueType)
Declaration
public void BuildIntegerDataValueTypeSqlText(StringBuilder sb, IntegerDataValueType integerDataValueType)
Parameters
BuildIntegrityCheckDeleteTriggerFooterBody(StringBuilder)
Declaration
public abstract void BuildIntegrityCheckDeleteTriggerFooterBody(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
BuildIntegrityCheckDeleteTriggerHeaderBody(StringBuilder)
Declaration
public abstract void BuildIntegrityCheckDeleteTriggerHeaderBody(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
BuildIntegrityCheckModifyTriggerCheckModifyBody(StringBuilder, String, String, String)
Declaration
public abstract void BuildIntegrityCheckModifyTriggerCheckModifyBody(StringBuilder sb, string referenceSchemaName, string columnValueName, string referenceSchemaPrimaryColumnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
referenceSchemaName |
|
System.String |
columnValueName |
|
System.String |
referenceSchemaPrimaryColumnName |
|
BuildIntegrityCheckModifyTriggerFooterBody(StringBuilder, String)
Declaration
public abstract void BuildIntegrityCheckModifyTriggerFooterBody(StringBuilder sb, string entitySchemaName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
entitySchemaName |
|
BuildIntegrityCheckModifyTriggerHeaderBody(StringBuilder)
Declaration
public abstract void BuildIntegrityCheckModifyTriggerHeaderBody(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
BuildIntegrityCheckModifyTriggerModifyBodyCheckForNullColumn(StringBuilder, String, EntitySchemaColumnRequirementType)
Declaration
public abstract void BuildIntegrityCheckModifyTriggerModifyBodyCheckForNullColumn(StringBuilder sb, string columnValueName, EntitySchemaColumnRequirementType columnRequirementType)
Parameters
Declaration
protected void BuildIntegrityCheckTriggerInsertNullMetaTagFooter(StringBuilder sb, string columnValueName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
columnValueName |
|
BuildIntegrityCheckTriggerInsertNullMetaTagHeder(StringBuilder, String)
Declaration
protected void BuildIntegrityCheckTriggerInsertNullMetaTagHeder(StringBuilder sb, string columnValueName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
columnValueName |
|
BuildJoinsSqlText(StringBuilder, JoinCollection)
Declaration
protected virtual void BuildJoinsSqlText(StringBuilder sb, JoinCollection joins)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
JoinCollection |
joins |
|
BuildLevelColumnSqlText(StringBuilder, String, HierarchicalSelectOptions)
Declaration
protected void BuildLevelColumnSqlText(StringBuilder sb, string name, HierarchicalSelectOptions options)
Parameters
BuildModifyQuerySourceSqlText(StringBuilder, ModifyQuerySource)
Declaration
protected virtual void BuildModifyQuerySourceSqlText(StringBuilder sb, ModifyQuerySource modifySource)
Parameters
BuildMultiRowInsertContent(StringBuilder, List<ModifyQueryColumnValueCollection>)
Declaration
protected virtual void BuildMultiRowInsertContent(StringBuilder sb, List<ModifyQueryColumnValueCollection> columnValues)
Parameters
BuildNextValueSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for getting next value for sequence. sb
.
Declaration
public abstract void BuildNextValueSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
BuildNoLockHintSqlText(StringBuilder, NoLockHint)
Declaration
public abstract void BuildNoLockHintSqlText(StringBuilder sb, NoLockHint noLockSqlHint)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
NoLockHint |
noLockSqlHint |
|
BuildNullableColumnDefinitionSqlText(StringBuilder, EntitySchema, String, EntitySchemaColumn, String)
Declaration
public abstract void BuildNullableColumnDefinitionSqlText(StringBuilder sb, EntitySchema entitySchema, string entitySchemaName, EntitySchemaColumn entitySchemaColumn, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
EntitySchema |
entitySchema |
|
System.String |
entitySchemaName |
|
EntitySchemaColumn |
entitySchemaColumn |
|
System.String |
columnName |
|
BuildOffsetFetchSqlText(StringBuilder, Int32, Int32)
Adds offset-fetch clause to sb
.
Declaration
protected virtual void BuildOffsetFetchSqlText(StringBuilder sb, int offset, int fetch)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for sql text string.
|
System.Int32 |
offset |
Offset value. Number of rows to skip.
|
System.Int32 |
fetch |
Number of rows to select.
|
BuildOrderByItemsSqlText(StringBuilder, OrderByItemCollection)
Declaration
protected void BuildOrderByItemsSqlText(StringBuilder sb, OrderByItemCollection orderByItems)
Parameters
BuildOrderByItemsSqlText(StringBuilder, Select)
Adds items for sorting from select
to sb
.
Declaration
protected void BuildOrderByItemsSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for sql text string.
|
Select |
select |
Select.
|
BuildOrderDirectionSqlText(StringBuilder, OrderDirection)
Declaration
public static void BuildOrderDirectionSqlText(StringBuilder sb, OrderDirection orderDirection)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
OrderDirection |
orderDirection |
|
BuildOrderDirectionSqlText(StringBuilder, OrderDirectionStrict)
Declaration
public static void BuildOrderDirectionSqlText(StringBuilder sb, OrderDirectionStrict orderDirection)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
OrderDirectionStrict |
orderDirection |
|
BuildOrderNullsPosition(StringBuilder, OrderByItem)
Declaration
protected virtual void BuildOrderNullsPosition(StringBuilder sb, OrderByItem orderByItem)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
OrderByItem |
orderByItem |
|
BuildOrderNullsPositionSqlText(StringBuilder, OrderDirectionStrict)
Declaration
protected virtual void BuildOrderNullsPositionSqlText(StringBuilder sb, OrderDirectionStrict orderDirection)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
OrderDirectionStrict |
orderDirection |
|
BuildParameterNameSqlText(StringBuilder, String)
Declaration
protected void BuildParameterNameSqlText(StringBuilder sb, string parameterName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
parameterName |
|
BuildParameterNameSqlText(StringBuilder, QueryParameter)
Declaration
public virtual void BuildParameterNameSqlText(StringBuilder sb, QueryParameter parameter)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
QueryParameter |
parameter |
|
BuildParameterValueSqlText(StringBuilder, Guid)
Declaration
protected void BuildParameterValueSqlText(StringBuilder sb, Guid value)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.Guid |
value |
|
BuildParameterValueSqlText(StringBuilder, DataValueType, Object)
Declaration
public void BuildParameterValueSqlText(StringBuilder sb, DataValueType dataValueType, object value)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
DataValueType |
dataValueType |
|
System.Object |
value |
|
BuildQualifyBaseStoredProcedureNameSqlText(StringBuilder, String, String)
Declaration
protected void BuildQualifyBaseStoredProcedureNameSqlText(StringBuilder sb, string packageName, string baseStoredProcedureName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
packageName |
|
System.String |
baseStoredProcedureName |
|
BuildQualifyNameSqlText(StringBuilder, String)
Declaration
public void BuildQualifyNameSqlText(StringBuilder sb, string name)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
name |
|
BuildQualifySchemaNameSqlText(StringBuilder, String, Boolean)
Declaration
public void BuildQualifySchemaNameSqlText(StringBuilder sb, string schemaName, bool appendCurrentSchemaName = true)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
schemaName |
|
System.Boolean |
appendCurrentSchemaName |
|
BuildQualifySchemaObjectNameSqlText(StringBuilder, String, String, Boolean)
Declaration
public void BuildQualifySchemaObjectNameSqlText(StringBuilder sb, string schemaName, string objectName, bool appendCurrentSchemaName = true)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
schemaName |
|
System.String |
objectName |
|
System.Boolean |
appendCurrentSchemaName |
|
BuildQueryColumnNameSqlText(StringBuilder, String, String)
Declaration
protected void BuildQueryColumnNameSqlText(StringBuilder sb, string sourceAlias, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
sourceAlias |
|
System.String |
columnName |
|
BuildQueryExpressionFullSqlText(StringBuilder, QueryColumnExpression)
Declaration
protected void BuildQueryExpressionFullSqlText(StringBuilder sb, QueryColumnExpression columnExpression)
Parameters
BuildQueryExpressionFullSqlText(StringBuilder, QuerySourceExpression)
Declaration
protected virtual void BuildQueryExpressionFullSqlText(StringBuilder sb, QuerySourceExpression sourceExpression)
Parameters
BuildQueryExpressionSqlText(StringBuilder, QueryColumnExpression)
Declaration
protected void BuildQueryExpressionSqlText(StringBuilder sb, QueryColumnExpression columnExpression)
Parameters
BuildQueryExpressionSqlText(StringBuilder, QueryColumnExpression, Boolean)
Declaration
protected void BuildQueryExpressionSqlText(StringBuilder sb, QueryColumnExpression columnExpression, bool needUpperExpression)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
QueryColumnExpression |
columnExpression |
|
System.Boolean |
needUpperExpression |
|
BuildQueryExpressionSqlText(StringBuilder, QuerySourceExpression)
Declaration
protected void BuildQueryExpressionSqlText(StringBuilder sb, QuerySourceExpression sourceExpression)
Parameters
BuildQueryExpressionsSqlText(StringBuilder, QueryColumnExpressionCollection)
Declaration
protected void BuildQueryExpressionsSqlText(StringBuilder sb, QueryColumnExpressionCollection columnExpressions)
Parameters
BuildQueryExpressionsSqlText(StringBuilder, QueryColumnExpressionCollection, Boolean)
Declaration
protected void BuildQueryExpressionsSqlText(StringBuilder sb, QueryColumnExpressionCollection columnExpressions, bool useUpperExpression)
Parameters
BuildQueryFunctionSqlText(StringBuilder, AggregationQueryFunction)
Declaration
public virtual void BuildQueryFunctionSqlText(StringBuilder sb, AggregationQueryFunction aggregationQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, CastQueryFunction)
Declaration
public void BuildQueryFunctionSqlText(StringBuilder sb, CastQueryFunction castQueryFunction)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
CastQueryFunction |
castQueryFunction |
|
BuildQueryFunctionSqlText(StringBuilder, CoalesceQueryFunction)
Declaration
public void BuildQueryFunctionSqlText(StringBuilder sb, CoalesceQueryFunction coalesceQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, ConcatQueryFunction)
Declaration
public virtual void BuildQueryFunctionSqlText(StringBuilder sb, ConcatQueryFunction concatQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, CreateGuidQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, CreateGuidQueryFunction createGuidQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, CurrentDateTimeQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, CurrentDateTimeQueryFunction currentDateTimeQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, CustomQueryFunction)
Builds the query function SQL text.
Declaration
public virtual void BuildQueryFunctionSqlText(StringBuilder sb, CustomQueryFunction customQueryFunction)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
String builder.
|
CustomQueryFunction |
customQueryFunction |
Custom query function.
|
BuildQueryFunctionSqlText(StringBuilder, DataLengthQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, DataLengthQueryFunction dataLengthQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, DateAddQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, DateAddQueryFunction dateAddQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, DateDiffQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, DateDiffQueryFunction dateDiffQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, DatePartQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, DatePartQueryFunction datePartQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, IsNullQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, IsNullQueryFunction isNullQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, LengthQueryFunction)
Declaration
public virtual void BuildQueryFunctionSqlText(StringBuilder sb, LengthQueryFunction lengthQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, RowNumberQueryFunction)
Declaration
public void BuildQueryFunctionSqlText(StringBuilder sb, RowNumberQueryFunction rowNumberQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, SubstringQueryFunction)
Declaration
public virtual void BuildQueryFunctionSqlText(StringBuilder sb, SubstringQueryFunction substringQueryFunction)
Parameters
BuildQueryFunctionSqlText(StringBuilder, TrimQueryFunction)
Declaration
public abstract void BuildQueryFunctionSqlText(StringBuilder sb, TrimQueryFunction trimQueryFunction)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
TrimQueryFunction |
trimQueryFunction |
|
BuildQueryFunctionSqlText(StringBuilder, UpperQueryFunction)
Declaration
public void BuildQueryFunctionSqlText(StringBuilder sb, UpperQueryFunction upperQueryFunction)
Parameters
BuildQueryHourMinuteFunctionSqlText(StringBuilder, DatePartQueryFunction)
Declaration
protected void BuildQueryHourMinuteFunctionSqlText(StringBuilder sb, DatePartQueryFunction datePartQueryFunction)
Parameters
BuildQuerySqlText(StringBuilder, Delete)
Declaration
public void BuildQuerySqlText(StringBuilder sb, Delete deleteQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Delete |
deleteQuery |
|
BuildQuerySqlText(StringBuilder, Insert)
Declaration
public void BuildQuerySqlText(StringBuilder sb, Insert insertQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Insert |
insertQuery |
|
BuildQuerySqlText(StringBuilder, InsertSelect)
Declaration
public void BuildQuerySqlText(StringBuilder sb, InsertSelect insertSelectQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
InsertSelect |
insertSelectQuery |
|
BuildQuerySqlText(StringBuilder, Select)
Declaration
public void BuildQuerySqlText(StringBuilder sb, Select selectQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
selectQuery |
|
BuildQuerySqlText(StringBuilder, StoredProcedure)
Declaration
public abstract void BuildQuerySqlText(StringBuilder sb, StoredProcedure storedProcedure)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
StoredProcedure |
storedProcedure |
|
BuildQuerySqlText(StringBuilder, Update)
Declaration
public void BuildQuerySqlText(StringBuilder sb, Update updateQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Update |
updateQuery |
|
BuildQuerySqlText(StringBuilder, UpdateSelect)
Declaration
public void BuildQuerySqlText(StringBuilder sb, UpdateSelect updateQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
UpdateSelect |
updateQuery |
|
BuildQuerySqlText(StringBuilder, UserDefinedFunction)
Declaration
public abstract void BuildQuerySqlText(StringBuilder sb, UserDefinedFunction userDefinedFunction)
Parameters
BuildReCreateSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for recreating sequence in DB.
Declaration
public abstract void BuildReCreateSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
BuildRenameConstraintSqlText(StringBuilder, ConstraintAction)
Declaration
public virtual void BuildRenameConstraintSqlText(StringBuilder sb, ConstraintAction action)
Parameters
BuildRenameEntitySchemaColumnSqlText(StringBuilder, ColumnAction)
Declaration
public virtual void BuildRenameEntitySchemaColumnSqlText(StringBuilder sb, ColumnAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ColumnAction |
action |
|
BuildRenameEntitySchemaSqlText(StringBuilder, EntitySchemaAction)
Declaration
public virtual void BuildRenameEntitySchemaSqlText(StringBuilder sb, EntitySchemaAction action)
Parameters
BuildRenameIndexSqlText(StringBuilder, IndexAction)
Declaration
public virtual void BuildRenameIndexSqlText(StringBuilder sb, IndexAction action)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
IndexAction |
action |
|
BuildRowLockHintSqlText(StringBuilder)
Builds RowLock table hint SQL text.
Declaration
public void BuildRowLockHintSqlText(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
System.Text.StringBuilder instance that forms the query text.
|
BuildSchemaColumnNameSqlText(StringBuilder, String)
Declaration
protected void BuildSchemaColumnNameSqlText(StringBuilder sb, string columnName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
columnName |
|
BuildSchemaColumnNameSqlText(StringBuilder, EntitySchemaColumn)
Declaration
public void BuildSchemaColumnNameSqlText(StringBuilder sb, EntitySchemaColumn column)
Parameters
BuildSelectColumnAliasesSqlText(StringBuilder, String, QueryColumnExpressionCollection)
Declaration
protected void BuildSelectColumnAliasesSqlText(StringBuilder sb, string sourceAlias, QueryColumnExpressionCollection columnExpressions)
Parameters
BuildSelectColumnAliasesSqlText(StringBuilder, QueryColumnExpressionCollection)
Declaration
protected void BuildSelectColumnAliasesSqlText(StringBuilder sb, QueryColumnExpressionCollection columnExpressions)
Parameters
BuildSelectColumnsSqlText(StringBuilder, QueryColumnExpressionCollection)
Declaration
protected void BuildSelectColumnsSqlText(StringBuilder sb, QueryColumnExpressionCollection columnExpressions)
Parameters
BuildSelectQuerySqlText(StringBuilder, Select)
Declaration
protected virtual void BuildSelectQuerySqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildSequenceArgumentSqlText<T>(StringBuilder, String, T)
Declaration
protected void BuildSequenceArgumentSqlText<T>(StringBuilder sb, string argName, T value)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
argName |
|
T |
value |
|
Type Parameters
BuildSequenceArgumentsSqlText(StringBuilder, Sequence)
Declaration
protected void BuildSequenceArgumentsSqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Sequence |
sequence |
|
BuildSingleRowInsertContent(StringBuilder, ModifyQueryColumnValueCollection)
Declaration
protected virtual void BuildSingleRowInsertContent(StringBuilder sb, ModifyQueryColumnValueCollection columnValues)
Parameters
BuildSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder, String, String, Guid)
Declaration
public abstract void BuildSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder sb, string referenceSchemaName, string referenceSchemaPrimaryColumnName, Guid sysSettingsId)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
referenceSchemaName |
|
System.String |
referenceSchemaPrimaryColumnName |
|
System.Guid |
sysSettingsId |
|
BuildSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder, Guid, SysSettingsReferenceSchemaCollection)
Declaration
public abstract void BuildSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder sb, Guid id, SysSettingsReferenceSchemaCollection referenceSchemaList)
Parameters
BuildSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder, EntitySchema)
Declaration
public abstract void BuildSysSettingsIntegrityCheckModifyTriggerBody(StringBuilder sb, EntitySchema referenceSchema)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
EntitySchema |
referenceSchema |
|
BuildSysSettingsIntegrityCheckModifyTriggerHeaderBody(StringBuilder)
Declaration
public abstract void BuildSysSettingsIntegrityCheckModifyTriggerHeaderBody(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
BuildTemporaryTableSourceExpressionSqlText(String)
Declaration
protected abstract string BuildTemporaryTableSourceExpressionSqlText(string tempTableName)
Parameters
Type |
Name |
Description |
System.String |
tempTableName |
|
Returns
Type |
Description |
System.String |
|
BuildTemporaryTableSqlText(StringBuilder, Select)
Declaration
protected virtual void BuildTemporaryTableSqlText(StringBuilder sb, Select select)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Select |
select |
|
BuildTextDataValueTypeSqlText(StringBuilder, TextDataValueType)
Declaration
public abstract void BuildTextDataValueTypeSqlText(StringBuilder sb, TextDataValueType textDataValueType)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
TextDataValueType |
textDataValueType |
|
BuildTimeValueSqlText(StringBuilder, DateTime)
Declaration
protected abstract void BuildTimeValueSqlText(StringBuilder sb, DateTime dateTimeValue)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.DateTime |
dateTimeValue |
|
BuildTimeValueSqlText(StringBuilder, TimeSpan)
Declaration
protected abstract void BuildTimeValueSqlText(StringBuilder sb, TimeSpan timeValue)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.TimeSpan |
timeValue |
|
BuildUpdateQuerySqlText(StringBuilder, Update)
Declaration
protected void BuildUpdateQuerySqlText(StringBuilder sb, Update updateQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Update |
updateQuery |
|
BuildUpdateSelectQuerySqlText(StringBuilder, UpdateSelect)
Declaration
protected virtual void BuildUpdateSelectQuerySqlText(StringBuilder sb, UpdateSelect updateQuery)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
UpdateSelect |
updateQuery |
|
BuildUpdateSelectTargetSqlText(StringBuilder, ModifyQuerySource, String)
Declaration
protected virtual void BuildUpdateSelectTargetSqlText(StringBuilder sb, ModifyQuerySource modifySource, string alias)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
ModifyQuerySource |
modifySource |
|
System.String |
alias |
|
BuildWindowQueryFunctionSqlText(StringBuilder, WindowQueryFunction)
Declaration
public virtual void BuildWindowQueryFunctionSqlText(StringBuilder sb, WindowQueryFunction windowQueryFunction)
Parameters
CheckIsArgumentNull(Object, String)
Declaration
protected void CheckIsArgumentNull(object value, string name)
Parameters
Type |
Name |
Description |
System.Object |
value |
|
System.String |
name |
|
CheckIsArgumentNullOrEmpty(String, String)
Declaration
protected void CheckIsArgumentNullOrEmpty(string value, string name)
Parameters
Type |
Name |
Description |
System.String |
value |
|
System.String |
name |
|
CreateCastToShortTextExpression(String)
Declaration
protected abstract QueryColumnExpression CreateCastToShortTextExpression(string columnAlias)
Parameters
Type |
Name |
Description |
System.String |
columnAlias |
|
Returns
CreateExplicitCastExpression(QueryColumnExpression, DBDataValueType)
Builds explicit cast expression SQL text.
Declaration
public QueryColumnExpression CreateExplicitCastExpression(QueryColumnExpression queryColumnExpression, DBDataValueType valueType)
Parameters
Returns
CreateUpperTextExpression(QueryColumnExpression)
Declaration
protected virtual QueryColumnExpression CreateUpperTextExpression(QueryColumnExpression expression)
Parameters
Returns
DeleteSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder, String, String)
Declaration
public void DeleteSysSettingsIntegrityCheckDeleteTriggerBody(StringBuilder sb, string triggerName, string integrityCheckBlockName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
triggerName |
|
System.String |
integrityCheckBlockName |
|
DeleteTriggerCreationKeywords(StringBuilder, String, String)
Declaration
public void DeleteTriggerCreationKeywords(StringBuilder sb, string triggerName, string referenceSchemaName)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
System.String |
triggerName |
|
System.String |
referenceSchemaName |
|
EqualsDataValueType(DataValueType, DataValueType)
Declaration
public virtual bool EqualsDataValueType(DataValueType dbColumnType, DataValueType schemaColumnType)
Parameters
Returns
Type |
Description |
System.Boolean |
|
Declaration
public abstract string FormatException(DbException exception)
Parameters
Type |
Name |
Description |
System.Data.Common.DbException |
exception |
|
Returns
Type |
Description |
System.String |
|
GetAdminUnitListQuery(Guid)
Declaration
public virtual IDBReadableCommand GetAdminUnitListQuery(Guid userId)
Parameters
Type |
Name |
Description |
System.Guid |
userId |
|
Returns
GetAdminUnitListWithoutUserTypesQuery(Guid)
Declaration
[Obsolete("7.15.4")]
public IDBReadableCommand GetAdminUnitListWithoutUserTypesQuery(Guid userId)
Parameters
Type |
Name |
Description |
System.Guid |
userId |
|
Returns
GetAppendBlobSqlText(String, String)
Declaration
public abstract string GetAppendBlobSqlText(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.String |
|
GetBitwiseNotOperationSqlText(StringBuilder, QueryColumnExpression)
Declaration
protected virtual void GetBitwiseNotOperationSqlText(StringBuilder sb, QueryColumnExpression columnExpression)
Parameters
GetBitwiseOperationSqlText(String, BitwiseOperation, String)
Declaration
public abstract string GetBitwiseOperationSqlText(string columnName, BitwiseOperation operation, string constant)
Parameters
Type |
Name |
Description |
System.String |
columnName |
|
BitwiseOperation |
operation |
|
System.String |
constant |
|
Returns
Type |
Description |
System.String |
|
GetBitwiseOperationSqlText(StringBuilder, QueryColumnExpression)
Declaration
protected virtual void GetBitwiseOperationSqlText(StringBuilder sb, QueryColumnExpression columnExpression)
Parameters
GetColumnDefValue(EntitySchemaColumn)
Declaration
public abstract string GetColumnDefValue(EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.String |
|
GetColumnDefValue(EntitySchemaColumn, Boolean)
Returns SQL text for default value of a column.
Declaration
public abstract string GetColumnDefValue(EntitySchemaColumn entitySchemaColumn, bool isWrapped)
Parameters
Type |
Name |
Description |
EntitySchemaColumn |
entitySchemaColumn |
Column.
|
System.Boolean |
isWrapped |
Flag that indicates whether value in text is wrapped in parentheses.
|
Returns
Type |
Description |
System.String |
SQL text for default value of a column.
|
GetColumnDefValue(EntitySchemaColumn, String)
Returns SQL text for default value of a column.
Declaration
public abstract string GetColumnDefValue(EntitySchemaColumn entitySchemaColumn, string dbDefValue)
Parameters
Type |
Name |
Description |
EntitySchemaColumn |
entitySchemaColumn |
Column.
|
System.String |
dbDefValue |
Default value format on database level.
|
Returns
Type |
Description |
System.String |
SQL text for default value of a column.
|
GetColumnForeignKeyQuerySqlText()
Declaration
public abstract string GetColumnForeignKeyQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetColumnIndexesQuerySqlText()
Declaration
public abstract string GetColumnIndexesQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetColumnListQuerySqlText()
Declaration
public abstract string GetColumnListQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetColumnQuerySqlText()
Declaration
public abstract string GetColumnQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetColumnsQuerySqlText()
Declaration
public virtual string GetColumnsQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetColumnsQuerySqlText(Boolean)
Declaration
public abstract string GetColumnsQuerySqlText(bool needGetConstraintType)
Parameters
Type |
Name |
Description |
System.Boolean |
needGetConstraintType |
|
Returns
Type |
Description |
System.String |
|
GetConstraintQuerySqlText()
Declaration
public abstract string GetConstraintQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetConstraintsQuerySqlText()
Declaration
public abstract string GetConstraintsQuerySqlText()
Returns
Type |
Description |
System.String |
|
Declaration
public virtual IDBReadableCommand GetContactCounters(Guid contactId)
Parameters
Type |
Name |
Description |
System.Guid |
contactId |
|
Returns
GetDanglingReferenceQuerySqlText(String, String, String, String, Boolean)
Declaration
public abstract string GetDanglingReferenceQuerySqlText(string entitySchemaName, string columnName, string referenceSchemaName, string referenceSchemaColumnName, bool skipGuidExpression)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
System.String |
referenceSchemaName |
|
System.String |
referenceSchemaColumnName |
|
System.Boolean |
skipGuidExpression |
|
Returns
Type |
Description |
System.String |
|
GetDateTimeValueKind(DbColumnDto)
Declaration
public abstract DateTimeValueKind GetDateTimeValueKind(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
DateTimeValueKind |
|
GetDaysOfWeekSqlText()
Declaration
public abstract string GetDaysOfWeekSqlText()
Returns
Type |
Description |
System.String |
|
GetEditPrimaryColumnDefinitionSqlText(IDataReader, EntitySchema, EntitySchemaColumn)
Declaration
public abstract string GetEditPrimaryColumnDefinitionSqlText(IDataReader dataReader, EntitySchema entitySchema, EntitySchemaColumn entitySchemaColumn)
Parameters
Returns
Type |
Description |
System.String |
|
GetForeignKeyParameterValue()
Declaration
public abstract string GetForeignKeyParameterValue()
Returns
Type |
Description |
System.String |
|
GetForeignKeyQuerySqlText()
Declaration
public abstract string GetForeignKeyQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetForeignKeysQuerySqlText()
Declaration
public abstract string GetForeignKeysQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetImageLookupAfterDeleteTriggerBody(String)
Declaration
public abstract string GetImageLookupAfterDeleteTriggerBody(string columnName)
Parameters
Type |
Name |
Description |
System.String |
columnName |
|
Returns
Type |
Description |
System.String |
|
GetImageLookupAfterInsertUpdateTriggerBody(String)
Declaration
public abstract string GetImageLookupAfterInsertUpdateTriggerBody(string columnName)
Parameters
Type |
Name |
Description |
System.String |
columnName |
|
Returns
Type |
Description |
System.String |
|
GetIndexesQuerySqlText()
Declaration
public abstract string GetIndexesQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetIndexQuerySqlText()
Declaration
public abstract string GetIndexQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetIsBinaryDataType(String)
Declaration
public abstract bool GetIsBinaryDataType(string dataTypeName)
Parameters
Type |
Name |
Description |
System.String |
dataTypeName |
|
Returns
Type |
Description |
System.Boolean |
|
GetIsEntitySchemaExistSqlText()
Declaration
public abstract string GetIsEntitySchemaExistSqlText()
Returns
Type |
Description |
System.String |
|
GetIsNotNullColumnSqlText()
Declaration
public abstract string GetIsNotNullColumnSqlText()
Returns
Type |
Description |
System.String |
|
GetIsOnlyLikeComparison(DataValueType)
Declaration
public abstract bool GetIsOnlyLikeComparison(DataValueType dataValueType)
Parameters
Returns
Type |
Description |
System.Boolean |
|
GetIsTextColumnContainGuidQuerySqlText(String, String)
Declaration
public abstract string GetIsTextColumnContainGuidQuerySqlText(string entitySchemaName, string columnName)
Parameters
Type |
Name |
Description |
System.String |
entitySchemaName |
|
System.String |
columnName |
|
Returns
Type |
Description |
System.String |
|
GetLogicalOperationSqlText(LogicalOperation)
Declaration
protected string GetLogicalOperationSqlText(LogicalOperation logicalOperation)
Parameters
Type |
Name |
Description |
LogicalOperation |
logicalOperation |
|
Returns
Type |
Description |
System.String |
|
GetPrimaryKeyParameterValue()
Declaration
public abstract string GetPrimaryKeyParameterValue()
Returns
Type |
Description |
System.String |
|
GetPrimaryKeyQuerySqlText()
Declaration
public abstract string GetPrimaryKeyQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetQualifySchemaObjectNameSqlText(String, String)
Declaration
public string GetQualifySchemaObjectNameSqlText(string schemaName, string objectName)
Parameters
Type |
Name |
Description |
System.String |
schemaName |
|
System.String |
objectName |
|
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Delete)
Declaration
public virtual string GetQuerySqlText(Delete deleteQuery)
Parameters
Type |
Name |
Description |
Delete |
deleteQuery |
|
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Insert)
Declaration
public virtual string GetQuerySqlText(Insert insertQuery)
Parameters
Type |
Name |
Description |
Insert |
insertQuery |
|
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(InsertSelect)
Declaration
public string GetQuerySqlText(InsertSelect insertSelectQuery)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Select)
Declaration
public virtual string GetQuerySqlText(Select selectQuery)
Parameters
Type |
Name |
Description |
Select |
selectQuery |
|
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Select, HierarchicalSelectOptions)
Declaration
public string GetQuerySqlText(Select select, HierarchicalSelectOptions options)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Select, Select, PageableSelectOptions, HierarchicalSelectOptions)
Declaration
public string GetQuerySqlText(Select mainSelect, Select select, PageableSelectOptions pageableOptions, HierarchicalSelectOptions hierarchicalOptions)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Sequence, Action<StringBuilder, Sequence>)
Returns SQL text depending on build sequence action.
Declaration
public string GetQuerySqlText(Sequence sequence, Action<StringBuilder, Sequence> buildSequenceFunc)
Parameters
Type |
Name |
Description |
Sequence |
sequence |
Sequence object.
|
System.Action<System.Text.StringBuilder, Sequence> |
buildSequenceFunc |
Sequence action in DBEngine.
|
Returns
Type |
Description |
System.String |
SQL text for sequence query.
|
GetQuerySqlText(StoredProcedure)
Declaration
public virtual string GetQuerySqlText(StoredProcedure storedProcedure)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(Update)
Declaration
public virtual string GetQuerySqlText(Update updateQuery)
Parameters
Type |
Name |
Description |
Update |
updateQuery |
|
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(UpdateSelect)
Declaration
public virtual string GetQuerySqlText(UpdateSelect updateQuery)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuerySqlText(UserDefinedFunction)
Declaration
public string GetQuerySqlText(UserDefinedFunction userDefinedFunction)
Parameters
Returns
Type |
Description |
System.String |
|
GetRefreshMaterializedViewSqlText(String)
Declaration
protected virtual string GetRefreshMaterializedViewSqlText(string viewName)
Parameters
Type |
Name |
Description |
System.String |
viewName |
|
Returns
Type |
Description |
System.String |
|
GetStartCheckIntegrityBlock(String)
Declaration
protected abstract string GetStartCheckIntegrityBlock(string checkEntitySchemaName)
Parameters
Type |
Name |
Description |
System.String |
checkEntitySchemaName |
|
Returns
Type |
Description |
System.String |
|
GetSysSchemaParentsInPackageHierarchySelectSqlText(Boolean)
Returns SQL text to get schema parents in package hierarchy.
Declaration
public abstract string GetSysSchemaParentsInPackageHierarchySelectSqlText(bool usePackageHierarchy)
Parameters
Type |
Name |
Description |
System.Boolean |
usePackageHierarchy |
Indicates whether to use package hierarchy or not.
|
Returns
Type |
Description |
System.String |
SQL text to get schema parents in package hierarchy.
|
GetSysSettingsIntegrityCheckBlockName(Guid)
Declaration
public abstract string GetSysSettingsIntegrityCheckBlockName(Guid sysSettingsId)
Parameters
Type |
Name |
Description |
System.Guid |
sysSettingsId |
|
Returns
Type |
Description |
System.String |
|
GetSystemValueSqlText(SystemValue)
Declaration
public abstract string GetSystemValueSqlText(SystemValue systemValue)
Parameters
Returns
Type |
Description |
System.String |
|
GetTriggerQuerySqlText()
Declaration
public abstract string GetTriggerQuerySqlText()
Returns
Type |
Description |
System.String |
|
GetTriggerSuffixName(TriggerType)
Declaration
protected string GetTriggerSuffixName(TriggerType triggerType)
Parameters
Returns
Type |
Description |
System.String |
|
GetTriggerTypeName(TriggerType)
Declaration
protected string GetTriggerTypeName(TriggerType triggerType)
Parameters
Returns
Type |
Description |
System.String |
|
GetUpdateSysSolutionRightAfterUnitDeleteSqlText()
Declaration
public abstract string GetUpdateSysSolutionRightAfterUnitDeleteSqlText()
Returns
Type |
Description |
System.String |
|
GetWorkspaceIdByNumberSelectSqlText()
Declaration
public abstract string GetWorkspaceIdByNumberSelectSqlText()
Returns
Type |
Description |
System.String |
|
Initialize(UserConnection, DBConfigurationSectionGroup)
Declaration
public virtual void Initialize(UserConnection userConnection, DBConfigurationSectionGroup dbConfigurationSectionGroup)
Parameters
InitializeDataValueDbData(BinaryDataValueType)
Declaration
public abstract void InitializeDataValueDbData(BinaryDataValueType dataValueType)
Parameters
InitializeDataValueDbData(BooleanDataValueType)
Declaration
public abstract void InitializeDataValueDbData(BooleanDataValueType dataValueType)
Parameters
InitializeDataValueDbData(DateDataValueType)
Declaration
public abstract void InitializeDataValueDbData(DateDataValueType dataValueType)
Parameters
InitializeDataValueDbData(DateTimeDataValueType)
Declaration
public abstract void InitializeDataValueDbData(DateTimeDataValueType dataValueType)
Parameters
InitializeDataValueDbData(DBObjectNameDataValueType)
Declaration
public abstract void InitializeDataValueDbData(DBObjectNameDataValueType dataValueType)
Parameters
InitializeDataValueDbData(FloatDataValueType)
Declaration
public abstract void InitializeDataValueDbData(FloatDataValueType dataValueType)
Parameters
InitializeDataValueDbData(GuidDataValueType)
Declaration
public abstract void InitializeDataValueDbData(GuidDataValueType dataValueType)
Parameters
InitializeDataValueDbData(IntegerDataValueType)
Declaration
public abstract void InitializeDataValueDbData(IntegerDataValueType dataValueType)
Parameters
InitializeDataValueDbData(TextDataValueType)
Declaration
public abstract void InitializeDataValueDbData(TextDataValueType dataValueType)
Parameters
InitializeDataValueDbData(TimeDataValueType)
Declaration
public abstract void InitializeDataValueDbData(TimeDataValueType dataValueType)
Parameters
InternalBuildDropSequenceQuerySqlText(StringBuilder, Sequence)
Builds SQL text for dropping sequence from DB. sb
.
Declaration
protected virtual void InternalBuildDropSequenceQuerySqlText(StringBuilder sb, Sequence sequence)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
Builder for SQL text string.
|
Sequence |
sequence |
Sequence object.
|
IsBinaryDataValueType(DbColumnDto)
Declaration
public virtual bool IsBinaryDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsBooleanDataValueType(DbColumnDto)
Declaration
public abstract bool IsBooleanDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsDateTimeDataValueType(DbColumnDto)
Declaration
public abstract bool IsDateTimeDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsDbObjectNameDataValueType(DbColumnDto)
Declaration
public abstract bool IsDbObjectNameDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsFloatDataValueType(DbColumnDto)
Declaration
public abstract bool IsFloatDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsGuidDataValueType(DbColumnDto)
Declaration
public abstract bool IsGuidDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsIntegerDataValueType(DbColumnDto)
Declaration
public abstract bool IsIntegerDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsLongTextType(DataValueType)
Declaration
protected bool IsLongTextType(DataValueType dataValueType)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsMaxSizeText(DbColumnDto)
Declaration
public abstract bool IsMaxSizeText(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsMaxSizeTextType(DataValueType)
Declaration
protected bool IsMaxSizeTextType(DataValueType dataValueType)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsTextDataValueType(DbColumnDto)
Declaration
public abstract bool IsTextDataValueType(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
IsUnicodeText(DbColumnDto)
Declaration
public abstract bool IsUnicodeText(DbColumnDto columnDto)
Parameters
Returns
Type |
Description |
System.Boolean |
|
NeedCastOrderedTextColumn(DataValueType)
Verifies whether cast an ordered column.
Declaration
public abstract bool NeedCastOrderedTextColumn(DataValueType orderedColumnDataValueType)
Parameters
Type |
Name |
Description |
DataValueType |
orderedColumnDataValueType |
Ordered column data value type.
|
Returns
Type |
Description |
System.Boolean |
Returns true if the specified ordered column needs a cast,
otherwise returns false.
|
NeedWrapFilterTextInUpperFunction(EntitySchemaQueryFilter)
Declaration
public abstract bool NeedWrapFilterTextInUpperFunction(EntitySchemaQueryFilter filter)
Parameters
Returns
Type |
Description |
System.Boolean |
|
PrepareDateTimeColumnValue(StringBuilder, DatePartQueryFunction)
Declaration
protected void PrepareDateTimeColumnValue(StringBuilder sb, DatePartQueryFunction datePartQueryFunction)
Parameters
PrepareDateTimeColumnValueByTimeZone(StringBuilder, QueryColumnExpression)
Declaration
protected void PrepareDateTimeColumnValueByTimeZone(StringBuilder sb, QueryColumnExpression expression)
Parameters
TriggerBodyHasIntegrityCheckBlocks(StringBuilder)
Declaration
public abstract bool TriggerBodyHasIntegrityCheckBlocks(StringBuilder sb)
Parameters
Type |
Name |
Description |
System.Text.StringBuilder |
sb |
|
Returns
Type |
Description |
System.Boolean |
|
Implements
Extension Methods