Class ProMsSqlDialect
Pro version of MS SQL Server dialect.
Inherits all OpenSource SQL from MsSqlDialect and adds Pro-specific SQL.
Uses , parameters and STRING_SPLIT for arrays.
public class ProMsSqlDialect : MsSqlDialect, ISqlDialectPro, ISqlDialectInheritance
Implements
Inherited Members
MsSqlDialect.FormatArrayContains(string, string),MsSqlDialect.FormatPagination(int?, int?),MsSqlDialect.FormatParameter(int),MsSqlDialect.FormatPvtColumn(long, string, string),MsSqlDialect.GetDbTypeName(string),MsSqlDialect.LazyLoader_GetObjectJson(),MsSqlDialect.LazyLoader_GetObjectJsonBatch(),MsSqlDialect.LazyLoader_SelectObjectBase(),MsSqlDialect.LazyLoader_SelectObjectHash(),MsSqlDialect.ListItems_Delete(),MsSqlDialect.ListItems_Insert(),MsSqlDialect.ListItems_SelectById(),MsSqlDialect.ListItems_SelectByListId(),MsSqlDialect.ListItems_SelectByListIdAndValue(),MsSqlDialect.ListItems_SelectByObjectId(),MsSqlDialect.ListItems_Update(),MsSqlDialect.ListItems_UpdateAliasAndObject(),MsSqlDialect.Lists_Delete(),MsSqlDialect.Lists_Insert(),MsSqlDialect.Lists_IsUsedInStructures(),MsSqlDialect.Lists_SelectAll(),MsSqlDialect.Lists_SelectById(),MsSqlDialect.Lists_SelectByName(),MsSqlDialect.Lists_Update(),MsSqlDialect.ObjectStorage_CheckObjectExists(),MsSqlDialect.ObjectStorage_DeleteById(),MsSqlDialect.ObjectStorage_DeleteByIds(),MsSqlDialect.ObjectStorage_DeleteValuesByObjectId(),MsSqlDialect.ObjectStorage_GetObjectJson(),MsSqlDialect.ObjectStorage_GetObjectsJsonBulk(),MsSqlDialect.ObjectStorage_InsertObject(),MsSqlDialect.ObjectStorage_LockObjectsForUpdate(),MsSqlDialect.ObjectStorage_SelectAllTypes(),MsSqlDialect.ObjectStorage_SelectExistingIds(),MsSqlDialect.ObjectStorage_SelectIdHash(),MsSqlDialect.ObjectStorage_SelectIdHashScheme(),MsSqlDialect.ObjectStorage_SelectObjectById(),MsSqlDialect.ObjectStorage_SelectObjectsByIds(),MsSqlDialect.ObjectStorage_SelectSchemeById(),MsSqlDialect.ObjectStorage_SelectSchemeIdByObjectId(),MsSqlDialect.ObjectStorage_SelectSchemeIdsForObjects(),MsSqlDialect.ObjectStorage_SelectSchemesByIds(),MsSqlDialect.ObjectStorage_SelectStructuresWithMetadata(),MsSqlDialect.ObjectStorage_SelectStructureTypes(),MsSqlDialect.ObjectStorage_SelectTypeById(),MsSqlDialect.ObjectStorage_SelectValueById(),MsSqlDialect.ObjectStorage_SelectValuesForObjects(),MsSqlDialect.ObjectStorage_SelectValuesWithTypes(),MsSqlDialect.ObjectStorage_UpdateObject(),MsSqlDialect.Permissions_Count(),MsSqlDialect.Permissions_CountByRole(),MsSqlDialect.Permissions_CountByUser(),MsSqlDialect.Permissions_Delete(),MsSqlDialect.Permissions_DeleteByRole(),MsSqlDialect.Permissions_DeleteByUser(),MsSqlDialect.Permissions_DeleteByUserRoleObject(),MsSqlDialect.Permissions_GetEffectiveForObject(),MsSqlDialect.Permissions_Insert(),MsSqlDialect.Permissions_SelectById(),MsSqlDialect.Permissions_SelectByObject(),MsSqlDialect.Permissions_SelectByRole(),MsSqlDialect.Permissions_SelectByUser(),MsSqlDialect.Permissions_SelectByUserRoleObject(),MsSqlDialect.Permissions_SelectReadableObjectIds(),MsSqlDialect.Permissions_SelectUserRoleIds(),MsSqlDialect.Permissions_Update(),MsSqlDialect.ProviderName,MsSqlDialect.Query_AggregateArrayGroupedSql(),MsSqlDialect.Query_AggregateBatchPreviewSql(),MsSqlDialect.Query_AggregateBatchSql(),MsSqlDialect.Query_AggregateFieldSql(),MsSqlDialect.Query_AggregateGroupedSql(),MsSqlDialect.Query_BigintArrayCast(),MsSqlDialect.Query_CheckPermissionSql(),MsSqlDialect.Query_CountTemplate(),MsSqlDialect.Query_GetIdsWithAncestorsSql(string),MsSqlDialect.Query_GetParentIdsFromDescendantsSql(string, int),MsSqlDialect.Query_HasAncestorNormalSql(string),MsSqlDialect.Query_HasAncestorTreeSql(string),MsSqlDialect.Query_HasDescendantSql(string),MsSqlDialect.Query_JsonCast(),MsSqlDialect.Query_LoadObjectsByIdsSql(string, int),MsSqlDialect.Query_ProjectionByIdsTemplate(string),MsSqlDialect.Query_ProjectionByPathsTemplate(),MsSqlDialect.Query_SearchFullTemplate(),MsSqlDialect.Query_SearchObjectsBaseFunction(),MsSqlDialect.Query_SearchObjectsFunction(),MsSqlDialect.Query_SearchObjectsProjectionByIdsFunction(),MsSqlDialect.Query_SearchObjectsProjectionByPathsFunction(),MsSqlDialect.Query_SearchObjectsSimpleSql(),MsSqlDialect.Query_SearchTemplate(),MsSqlDialect.Query_SearchTreeObjectsBaseFunction(),MsSqlDialect.Query_SearchTreeObjectsFunction(),MsSqlDialect.Query_SearchWithDistinctTemplate(),MsSqlDialect.Query_SqlPreviewBaseFunction(),MsSqlDialect.Query_SqlPreviewFunction(),MsSqlDialect.Query_SqlPreviewTemplate(),MsSqlDialect.Query_TextArrayCast(),MsSqlDialect.Query_TreeCountNormalSql(string),MsSqlDialect.Query_TreeCountWithParentIdsSql(string),MsSqlDialect.Query_TreeSearchNormalSql(string),MsSqlDialect.Query_TreeSearchWithParentIdsSql(string),MsSqlDialect.Query_TreeSqlPreviewBaseFunction(),MsSqlDialect.Query_TreeSqlPreviewFunction(),MsSqlDialect.Query_TreeSqlPreviewTemplate(string),MsSqlDialect.Query_WindowSql(),MsSqlDialect.QuoteIdentifier(string),MsSqlDialect.Roles_Count(),MsSqlDialect.Roles_Delete(),MsSqlDialect.Roles_ExistsById(),MsSqlDialect.Roles_ExistsByName(),MsSqlDialect.Roles_ExistsByNameExcluding(),MsSqlDialect.Roles_Insert(),MsSqlDialect.Roles_SelectAll(),MsSqlDialect.Roles_SelectById(),MsSqlDialect.Roles_SelectByName(),MsSqlDialect.Roles_SelectConfigurationId(),MsSqlDialect.Roles_SelectIdByName(),MsSqlDialect.Roles_UpdateConfiguration(),MsSqlDialect.Roles_UpdateName(),MsSqlDialect.Schemes_ExistsByName(),MsSqlDialect.Schemes_GetStructureTree(),MsSqlDialect.Schemes_Insert(),MsSqlDialect.Schemes_InsertObject(),MsSqlDialect.Schemes_MigrateStructureType(),MsSqlDialect.Schemes_SelectAll(),MsSqlDialect.Schemes_SelectById(),MsSqlDialect.Schemes_SelectByName(),MsSqlDialect.Schemes_SelectHashById(),MsSqlDialect.Schemes_SelectObjectByName(),MsSqlDialect.Schemes_SyncMetadataCache(),MsSqlDialect.Schemes_UpdateHash(),MsSqlDialect.Schemes_UpdateName(),MsSqlDialect.SoftDelete_ClaimOrphanedTask(),MsSqlDialect.SoftDelete_GetDeletionProgress(),MsSqlDialect.SoftDelete_GetOrphanedTasks(),MsSqlDialect.SoftDelete_GetUserActiveDeletions(),MsSqlDialect.SoftDelete_MarkForDeletion(),MsSqlDialect.SoftDelete_PurgeTrash(),MsSqlDialect.Structures_DeleteByIds(IEnumerable<long>),MsSqlDialect.Structures_Insert(),MsSqlDialect.Structures_SelectByScheme(),MsSqlDialect.Structures_SelectBySchemeCacheable(),MsSqlDialect.Structures_SelectBySchemeShort(),MsSqlDialect.Structures_UpdateAlias(),MsSqlDialect.Structures_UpdateAllowNotNull(),MsSqlDialect.Structures_UpdateCollectionType(),MsSqlDialect.Structures_UpdateKeyType(),MsSqlDialect.Structures_UpdateType(),MsSqlDialect.Tree_DeleteObjectsByIds(),MsSqlDialect.Tree_DeleteValuesByObjectIds(),MsSqlDialect.Tree_GetObjectJson(),MsSqlDialect.Tree_ObjectExists(),MsSqlDialect.Tree_SelectChildrenBase(),MsSqlDialect.Tree_SelectChildrenBySchemeBase(),MsSqlDialect.Tree_SelectChildrenJson(),MsSqlDialect.Tree_SelectParentId(),MsSqlDialect.Tree_SelectPolymorphicChildren(),MsSqlDialect.Tree_SelectSchemeAndJson(),MsSqlDialect.Tree_UpdateParent(),MsSqlDialect.Types_SelectAll(),MsSqlDialect.Types_SelectByName(),MsSqlDialect.Users_Count(),MsSqlDialect.Users_CountEnabled(),MsSqlDialect.Users_ExistsByEmail(),MsSqlDialect.Users_ExistsById(),MsSqlDialect.Users_ExistsByLogin(),MsSqlDialect.Users_ExistsByLoginExcluding(),MsSqlDialect.Users_Insert(),MsSqlDialect.Users_SelectById(),MsSqlDialect.Users_SelectByLogin(),MsSqlDialect.Users_SelectConfigurationId(),MsSqlDialect.Users_SelectIdByLogin(),MsSqlDialect.Users_SoftDelete(),MsSqlDialect.Users_Update(),MsSqlDialect.Users_UpdateConfiguration(),MsSqlDialect.Users_UpdatePassword(),MsSqlDialect.Users_UpdateStatus(),MsSqlDialect.UsersRoles_CountByRole(),MsSqlDialect.UsersRoles_Delete(),MsSqlDialect.UsersRoles_DeleteByRole(),MsSqlDialect.UsersRoles_DeleteByUser(),MsSqlDialect.UsersRoles_Exists(),MsSqlDialect.UsersRoles_Insert(),MsSqlDialect.UsersRoles_SelectRolesByUser(),MsSqlDialect.UsersRoles_SelectUsersByRole(),MsSqlDialect.Validation_SelectAllTypes(),MsSqlDialect.Validation_SelectSchemeByName(),MsSqlDialect.Validation_SelectStructuresBySchemeId(),MsSqlDialect.Warmup_AllMetadataCaches(),MsSqlDialect.WrapSubquery(string, string)
Methods
Materialization_SelectListItemsByIds()
Bulk select list items by IDs.
public string Materialization_SelectListItemsByIds()Materialization_SelectObjectById()
Select object by ID with all base fields.
public string Materialization_SelectObjectById()Materialization_SelectObjectsByIds()
Bulk select objects by IDs (for nested objects).
public string Materialization_SelectObjectsByIds()Materialization_SelectValuesByObjectAndStructureIds()
Bulk select values by object IDs and structure IDs.
public string Materialization_SelectValuesByObjectAndStructureIds()Materialization_SelectValuesByObjectIds()
Bulk select values by object IDs.
public string Materialization_SelectValuesByObjectIds()Migration_SelectExpressionHash()
Get expression hash for migration.
public string Migration_SelectExpressionHash()SchemeResolver_SelectChildField()
Select field metadata by scheme, name, and parent structure.
public string SchemeResolver_SelectChildField()SchemeResolver_SelectRootField()
Select field metadata by scheme, name, and no parent (root field).
public string SchemeResolver_SelectRootField()SchemeResolver_SelectRootFieldsIn(int)
Select multiple root fields by names (IN clause).
public string SchemeResolver_SelectRootFieldsIn(int fieldCount)