Class ProPostgreSqlDialect
Pro version of PostgreSQL dialect.
Inherits all OpenSource SQL from PostgreSqlDialect and adds Pro-specific SQL.
public class ProPostgreSqlDialect : PostgreSqlDialect, ISqlDialectPro, ISqlDialectInheritance
Implements
Inherited Members
PostgreSqlDialect.FormatArrayContains(string, string),PostgreSqlDialect.FormatPagination(int?, int?),PostgreSqlDialect.FormatParameter(int),PostgreSqlDialect.FormatPvtColumn(long, string, string),PostgreSqlDialect.GetDbTypeName(string),PostgreSqlDialect.LazyLoader_GetObjectJson(),PostgreSqlDialect.LazyLoader_GetObjectJsonBatch(),PostgreSqlDialect.LazyLoader_SelectObjectBase(),PostgreSqlDialect.LazyLoader_SelectObjectHash(),PostgreSqlDialect.ListItems_Delete(),PostgreSqlDialect.ListItems_Insert(),PostgreSqlDialect.ListItems_SelectById(),PostgreSqlDialect.ListItems_SelectByListId(),PostgreSqlDialect.ListItems_SelectByListIdAndValue(),PostgreSqlDialect.ListItems_SelectByObjectId(),PostgreSqlDialect.ListItems_Update(),PostgreSqlDialect.ListItems_UpdateAliasAndObject(),PostgreSqlDialect.Lists_Delete(),PostgreSqlDialect.Lists_Insert(),PostgreSqlDialect.Lists_IsUsedInStructures(),PostgreSqlDialect.Lists_SelectAll(),PostgreSqlDialect.Lists_SelectById(),PostgreSqlDialect.Lists_SelectByName(),PostgreSqlDialect.Lists_Update(),PostgreSqlDialect.ObjectStorage_CheckObjectExists(),PostgreSqlDialect.ObjectStorage_DeleteById(),PostgreSqlDialect.ObjectStorage_DeleteByIds(),PostgreSqlDialect.ObjectStorage_DeleteValuesByObjectId(),PostgreSqlDialect.ObjectStorage_GetObjectJson(),PostgreSqlDialect.ObjectStorage_GetObjectsJsonBulk(),PostgreSqlDialect.ObjectStorage_InsertObject(),PostgreSqlDialect.ObjectStorage_LockObjectsForUpdate(),PostgreSqlDialect.ObjectStorage_SelectAllTypes(),PostgreSqlDialect.ObjectStorage_SelectExistingIds(),PostgreSqlDialect.ObjectStorage_SelectIdHash(),PostgreSqlDialect.ObjectStorage_SelectIdHashScheme(),PostgreSqlDialect.ObjectStorage_SelectObjectById(),PostgreSqlDialect.ObjectStorage_SelectObjectsByIds(),PostgreSqlDialect.ObjectStorage_SelectSchemeById(),PostgreSqlDialect.ObjectStorage_SelectSchemeIdByObjectId(),PostgreSqlDialect.ObjectStorage_SelectSchemeIdsForObjects(),PostgreSqlDialect.ObjectStorage_SelectSchemesByIds(),PostgreSqlDialect.ObjectStorage_SelectStructuresWithMetadata(),PostgreSqlDialect.ObjectStorage_SelectStructureTypes(),PostgreSqlDialect.ObjectStorage_SelectTypeById(),PostgreSqlDialect.ObjectStorage_SelectValueById(),PostgreSqlDialect.ObjectStorage_SelectValuesForObjects(),PostgreSqlDialect.ObjectStorage_SelectValuesWithTypes(),PostgreSqlDialect.ObjectStorage_UpdateObject(),PostgreSqlDialect.Permissions_Count(),PostgreSqlDialect.Permissions_CountByRole(),PostgreSqlDialect.Permissions_CountByUser(),PostgreSqlDialect.Permissions_Delete(),PostgreSqlDialect.Permissions_DeleteByRole(),PostgreSqlDialect.Permissions_DeleteByUser(),PostgreSqlDialect.Permissions_DeleteByUserRoleObject(),PostgreSqlDialect.Permissions_GetEffectiveForObject(),PostgreSqlDialect.Permissions_Insert(),PostgreSqlDialect.Permissions_SelectById(),PostgreSqlDialect.Permissions_SelectByObject(),PostgreSqlDialect.Permissions_SelectByRole(),PostgreSqlDialect.Permissions_SelectByUser(),PostgreSqlDialect.Permissions_SelectByUserRoleObject(),PostgreSqlDialect.Permissions_SelectReadableObjectIds(),PostgreSqlDialect.Permissions_SelectUserRoleIds(),PostgreSqlDialect.Permissions_Update(),PostgreSqlDialect.ProviderName,PostgreSqlDialect.Query_AggregateArrayGroupedSql(),PostgreSqlDialect.Query_AggregateBatchPreviewSql(),PostgreSqlDialect.Query_AggregateBatchSql(),PostgreSqlDialect.Query_AggregateFieldSql(),PostgreSqlDialect.Query_AggregateGroupedSql(),PostgreSqlDialect.Query_BigintArrayCast(),PostgreSqlDialect.Query_CheckPermissionSql(),PostgreSqlDialect.Query_CountTemplate(),PostgreSqlDialect.Query_GetIdsWithAncestorsSql(string),PostgreSqlDialect.Query_GetParentIdsFromDescendantsSql(string, int),PostgreSqlDialect.Query_HasAncestorNormalSql(string),PostgreSqlDialect.Query_HasAncestorTreeSql(string),PostgreSqlDialect.Query_HasDescendantSql(string),PostgreSqlDialect.Query_JsonCast(),PostgreSqlDialect.Query_LoadObjectsByIdsSql(string, int),PostgreSqlDialect.Query_ProjectionByIdsTemplate(string),PostgreSqlDialect.Query_ProjectionByPathsTemplate(),PostgreSqlDialect.Query_SearchFullTemplate(),PostgreSqlDialect.Query_SearchObjectsBaseFunction(),PostgreSqlDialect.Query_SearchObjectsFunction(),PostgreSqlDialect.Query_SearchObjectsProjectionByIdsFunction(),PostgreSqlDialect.Query_SearchObjectsProjectionByPathsFunction(),PostgreSqlDialect.Query_SearchObjectsSimpleSql(),PostgreSqlDialect.Query_SearchTemplate(),PostgreSqlDialect.Query_SearchTreeObjectsBaseFunction(),PostgreSqlDialect.Query_SearchTreeObjectsFunction(),PostgreSqlDialect.Query_SearchWithDistinctTemplate(),PostgreSqlDialect.Query_SqlPreviewBaseFunction(),PostgreSqlDialect.Query_SqlPreviewFunction(),PostgreSqlDialect.Query_SqlPreviewTemplate(),PostgreSqlDialect.Query_TextArrayCast(),PostgreSqlDialect.Query_TreeCountNormalSql(string),PostgreSqlDialect.Query_TreeCountWithParentIdsSql(string),PostgreSqlDialect.Query_TreeSearchNormalSql(string),PostgreSqlDialect.Query_TreeSearchWithParentIdsSql(string),PostgreSqlDialect.Query_TreeSqlPreviewBaseFunction(),PostgreSqlDialect.Query_TreeSqlPreviewFunction(),PostgreSqlDialect.Query_TreeSqlPreviewTemplate(string),PostgreSqlDialect.Query_WindowSql(),PostgreSqlDialect.QuoteIdentifier(string),PostgreSqlDialect.Roles_Count(),PostgreSqlDialect.Roles_Delete(),PostgreSqlDialect.Roles_ExistsById(),PostgreSqlDialect.Roles_ExistsByName(),PostgreSqlDialect.Roles_ExistsByNameExcluding(),PostgreSqlDialect.Roles_Insert(),PostgreSqlDialect.Roles_SelectAll(),PostgreSqlDialect.Roles_SelectById(),PostgreSqlDialect.Roles_SelectByName(),PostgreSqlDialect.Roles_SelectConfigurationId(),PostgreSqlDialect.Roles_SelectIdByName(),PostgreSqlDialect.Roles_UpdateConfiguration(),PostgreSqlDialect.Roles_UpdateName(),PostgreSqlDialect.Schemes_ExistsByName(),PostgreSqlDialect.Schemes_GetStructureTree(),PostgreSqlDialect.Schemes_Insert(),PostgreSqlDialect.Schemes_InsertObject(),PostgreSqlDialect.Schemes_MigrateStructureType(),PostgreSqlDialect.Schemes_SelectAll(),PostgreSqlDialect.Schemes_SelectById(),PostgreSqlDialect.Schemes_SelectByName(),PostgreSqlDialect.Schemes_SelectHashById(),PostgreSqlDialect.Schemes_SelectObjectByName(),PostgreSqlDialect.Schemes_SyncMetadataCache(),PostgreSqlDialect.Schemes_UpdateHash(),PostgreSqlDialect.Schemes_UpdateName(),PostgreSqlDialect.SoftDelete_ClaimOrphanedTask(),PostgreSqlDialect.SoftDelete_GetDeletionProgress(),PostgreSqlDialect.SoftDelete_GetOrphanedTasks(),PostgreSqlDialect.SoftDelete_GetUserActiveDeletions(),PostgreSqlDialect.SoftDelete_MarkForDeletion(),PostgreSqlDialect.SoftDelete_PurgeTrash(),PostgreSqlDialect.Structures_DeleteByIds(IEnumerable<long>),PostgreSqlDialect.Structures_Insert(),PostgreSqlDialect.Structures_SelectByScheme(),PostgreSqlDialect.Structures_SelectBySchemeCacheable(),PostgreSqlDialect.Structures_SelectBySchemeShort(),PostgreSqlDialect.Structures_UpdateAlias(),PostgreSqlDialect.Structures_UpdateAllowNotNull(),PostgreSqlDialect.Structures_UpdateCollectionType(),PostgreSqlDialect.Structures_UpdateKeyType(),PostgreSqlDialect.Structures_UpdateType(),PostgreSqlDialect.Tree_DeleteObjectsByIds(),PostgreSqlDialect.Tree_DeleteValuesByObjectIds(),PostgreSqlDialect.Tree_GetObjectJson(),PostgreSqlDialect.Tree_ObjectExists(),PostgreSqlDialect.Tree_SelectChildrenBase(),PostgreSqlDialect.Tree_SelectChildrenBySchemeBase(),PostgreSqlDialect.Tree_SelectChildrenJson(),PostgreSqlDialect.Tree_SelectParentId(),PostgreSqlDialect.Tree_SelectPolymorphicChildren(),PostgreSqlDialect.Tree_SelectSchemeAndJson(),PostgreSqlDialect.Tree_UpdateParent(),PostgreSqlDialect.Types_SelectAll(),PostgreSqlDialect.Types_SelectByName(),PostgreSqlDialect.Users_Count(),PostgreSqlDialect.Users_CountEnabled(),PostgreSqlDialect.Users_ExistsByEmail(),PostgreSqlDialect.Users_ExistsById(),PostgreSqlDialect.Users_ExistsByLogin(),PostgreSqlDialect.Users_ExistsByLoginExcluding(),PostgreSqlDialect.Users_Insert(),PostgreSqlDialect.Users_SelectById(),PostgreSqlDialect.Users_SelectByLogin(),PostgreSqlDialect.Users_SelectConfigurationId(),PostgreSqlDialect.Users_SelectIdByLogin(),PostgreSqlDialect.Users_SoftDelete(),PostgreSqlDialect.Users_Update(),PostgreSqlDialect.Users_UpdateConfiguration(),PostgreSqlDialect.Users_UpdatePassword(),PostgreSqlDialect.Users_UpdateStatus(),PostgreSqlDialect.UsersRoles_CountByRole(),PostgreSqlDialect.UsersRoles_Delete(),PostgreSqlDialect.UsersRoles_DeleteByRole(),PostgreSqlDialect.UsersRoles_DeleteByUser(),PostgreSqlDialect.UsersRoles_Exists(),PostgreSqlDialect.UsersRoles_Insert(),PostgreSqlDialect.UsersRoles_SelectRolesByUser(),PostgreSqlDialect.UsersRoles_SelectUsersByRole(),PostgreSqlDialect.Validation_SelectAllTypes(),PostgreSqlDialect.Validation_SelectSchemeByName(),PostgreSqlDialect.Validation_SelectStructuresBySchemeId(),PostgreSqlDialect.Warmup_AllMetadataCaches(),PostgreSqlDialect.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)