DistinctFilteringPreferenceType Enumeration

LLBLGen Pro v5.2 Runtime Framework Reference Manual

LLBLGen Pro v5.2 Runtime Framework Reference Manual

SD.LLBLGen.Pro.ORMSupportClasses Namespaces

SD.LLBLGen.Pro.ORMSupportClasses

ActionQuery Class

ActionQueueElement(TEntity) Class

AggregateFunction Enumeration

AggregateSetFunction Enumeration

AggregateSetPredicate Class

AggregateSetPredicateCallback Delegate

AliasScope Class

ArgumentVerifier Class

AuditorBase Class

AuthorizerBase Class

BatchActionQuery Class

BooleanCharYNConverter Class

BooleanNumericConverter Class

BuildInValidationBypass Enumeration

ByteDecimalConverter Class

CacheableChecker Class

CacheController Class

CachedResultset Class

CachedResultsetDataReader Class

CacheItem(T) Class

CancelableCollectionChangedEventArgs Class

CancelableDataSourceActionEventArgs Class

CascadeActionType Enumeration

CatalogNameOverwriteHashtable Class

CatalogNameUsage Enumeration

CharStringConverter Class

CollectionChangedEventArgs Class

CollectionCore(T) Class

ComparisonOperator Enumeration

ComPlusAdapterContextBase Class

ConcurrencyPredicateType Enumeration

ConfigFileHelper Class

CorrelationPredicateExpression Class

CustomXmlSerializationAttribute Class

DataAccessAdapterBase Class

DataAccessAdapterCore Class

DataProjectorToCustomClass(T) Class

DataProjectorToDataTable Class

DataProjectorToEntityCollectionBase Class

DataProjectorToIEntityCollection Class

DataProjectorToIEntityCollection2 Class

DataProjectorToObjectRowList Class

DataProjectorToValueList(T) Class

DataReaderProjectionRow Class

DataScope Class

DataScopeRefetchStrategyType Enumeration

DataSourceActionEventArgs Class

DataSourceCacheLocation Enumeration

DataSourceDataContainerType Enumeration

DataSourceDesigner2ConfigurationForm Class

DataSourceDesignerConfigurationForm Class

DataSourceSortingMode Enumeration

DataTableFiller Class

DataValueProjector Class

DateTimeDateTimeUTCConverter Class

DbFunctionCall Class

DbProviderFactoryInfo Class

DbSpecificCreatorBase Class

DelegatePredicate Class

DelegatePredicate(TEntity) Class

DelegatePredicateCallback Delegate

DependencyInjectionConfigInformation Class

DependencyInjectionContextType Enumeration

DependencyInjectionDiscoveryInformation Class

DependencyInjectionInfoAttribute Class

DependencyInjectionInfoProviderSingleton Class

DependencyInjectionScope Class

DependencyInjectionSectionHandler Class

DependencyInjectionTargetKind Enumeration

DerivedTableDefinition Class

DerivedTableFieldPresence Enumeration

DerivedTableFinder Class

DerivedTableTargetingFieldFinder Class

DesignTimeTracker Class

DistinctFilteringPreferenceType Enumeration

DoubleDecimalConverter Class

DynamicQueryEngineBase Class

DynamicRelationBase Class

ElementCreatorBase Class

EntityBase Class

EntityBase2 Class

EntityCollectionBase(TEntity) Class

EntityCollectionBase2(TEntity) Class

EntityCollectionNonGeneric Class

EntityCore(TFields) Class

EntityFactoryCache2 Class

EntityFactoryCore Class

EntityFactoryCore2 Class

EntityField Class

EntityField2 Class

EntityFieldCore Class

EntityFieldPersistenceInfoList Class

EntityFields Class

EntityFields2 Class

EntityFieldsCore(TField) Class

EntityProperty Class

EntityPropertyDescriptor Class

EntityPropertyProjector Class

EntityRelation Class

EntityState Enumeration

EntitySyncInfo(TEntity) Class

EntityView(TEntity) Class

EntityView2(TEntity) Class

EntityViewBase(TEntity) Class

ExceptionInfoElement Enumeration

ExceptionInfoRetriever Class

ExcludeFieldsList Class

ExcludeIncludeFieldsList Class

ExOp Enumeration

Expression Class

ExpressionElement(T) Class

ExpressionElementType Enumeration

ExpressionFieldElement Class

ExtensionMethods Class

FastDeserializer Class

FastDictionary(TKey, TValue) Class

FastSerializer Class

FastSerializerSurrogate Class

FastSerializerSurrogateSelector Class

FetchNewAuthorizationFailureResultHint Enumeration

FieldBetweenPredicate Class

FieldCompareExpressionPredicate Class

FieldCompareNullPredicate Class

FieldCompareRangePredicate Class

FieldCompareSetPredicate Class

FieldCompareValuePredicate Class

FieldFullTextSearchPredicate Class

FieldInfo Class

FieldInfoProviderBase Class

FieldLikePredicate Class

FieldPersistenceInfo Class

FieldStateBucket Structure

FieldUtilities Class

FirebirdCompatibilityLevel Enumeration

FromClauseElementDirective Class

FromClauseElementDirectiveType Enumeration

FullTextSearchOperator Enumeration

FunctionMapping Class

FunctionMappingStore Class

GeneralUtils Class

GenericExpressionVisitor Class

GroupByCollection Class

GuidByteArrayConverter Class

GuidStringConverter Class

IActionQuery Interface

IActiveContextParticipant Interface

IAuditor Interface

IAuthorizer Interface

IByteCompressor Interface

IConcurrencyPredicateFactory Interface

IContextAwareElement Interface

IDataAccessAdapter Interface

IDataAccessCore Interface

IDataValueProjector Interface

IDbFunctionCall Interface

IDbSpecificCreator Interface

IDbSpecificHintCreator Interface

IDerivedTableDefinition Interface

IDynamicRelation Interface

IElementCreator Interface

IElementCreator2 Interface

IElementCreatorCore Interface

IEntity Interface

IEntity2 Interface

IEntityCollection Interface

IEntityCollection2 Interface

IEntityCollectionCore Interface

IEntityCore Interface

IEntityDataProjector Interface

IEntityFactory Interface

IEntityFactory2 Interface

IEntityFactoryCore Interface

IEntityField Interface

IEntityField2 Interface

IEntityFieldCore Interface

IEntityFieldCoreInterpret Interface

IEntityFields Interface

IEntityFields2 Interface

IEntityFieldsCore Interface

IEntityPropertyProjector Interface

IEntityRelation Interface

IEntityView Interface

IEntityView2 Interface

IEntityViewCore Interface

IExpression Interface

IExpressionElement Interface

IExpressionFieldElement Interface

IExpressionInterpret Interface

IFastSerializationTypeSurrogate Interface

IFieldInfo Interface

IFieldInfoProvider Interface

IFieldPersistenceInfo Interface

IGeneralDataProjector Interface

IGroupByCollection Interface

IInheritanceInfo Interface

IInheritanceInfoProvider Interface

IMemoryStreamByteCompressor Interface

IncludeFieldsList Class

IncludeInCompactXmlAttribute Class

InheritanceHierarchyType Enumeration

InheritanceInfo Class

InheritanceInfoProviderBase Class

Int16DecimalConverter Class

Int32DecimalConverter Class

Int64DecimalConverter Class

InterpretSetValueCallback Delegate

IOwnedDataSerializable Interface

IOwnedDataSerializableAndRecreatable Interface

IParameterFieldRelation Interface

IPersistenceInfoProvider Interface

IPredicate Interface

IPredicateExpression Interface

IPredicateExpressionElement Interface

IPredicateInterpret Interface

IPrefetchPath Interface

IPrefetchPath2 Interface

IPrefetchPathCore Interface

IPrefetchPathElement Interface

IPrefetchPathElement2 Interface

IPrefetchPathElementCore Interface

IProjector Interface

IPropertyDescriptorFactory Interface

IQuery Interface

IRelation Interface

IRelationCollection Interface

IRelationFactory Interface

IRelationPredicateBucket Interface

IResultsetCache Interface

IRetrievalQuery Interface

IScalarQueryExpression Interface

ISequenceRetrievalQuery Interface

ISortClause Interface

ISortExpression Interface

ITransaction Interface

ITransactionalElement Interface

ITransactionController Interface

ITypeDefaultValue Interface

ITypedListCore Interface

ITypedListLgp Interface

ITypedListLgp2 Interface

ITypedView Interface

ITypedView2 Interface

IUnitOfWorkCore Interface

IValidator Interface

IViewProjectionData Interface

JoinHint Enumeration

LLBLGenProDataSource Class

LLBLGenProDataSource2 Class

LLBLGenProDataSourceBase Class

LLBLGenProDataSourceDesigner Class

LLBLGenProDataSourceDesigner2 Class

LLBLGenProDataSourceView Class

LLBLGenProDataSourceView2 Class

LLBLGenProDataSourceViewBase Class

LLBLGenProDesignerDataSourceView Class

LLBLGenProDesignerDataSourceView2 Class

MemberOperator Enumeration

MemberPredicate Class

MergeableDictionary(TKey, TValue) Class

MultiValueDictionary(TKey, TValue) Class

MultiValueHashtable(TKey, TValue) Class

NavigatorAspectType Enumeration

NodeEntityReference Class

NumericValueOperatorExecutor Class

ObjectGraphUtils Class

OracleCompatibilityLevel Enumeration

ORMBadSequenceException Class

ORMConcurrencyException Class

ORMEntityIsDeletedException Class

ORMEntityOutOfSyncException Class

ORMEntityValidationException Class

ORMException Class

ORMFieldIsNullException Class

ORMFieldIsReadonlyException Class

ORMGeneralOperationException Class

ORMInheritanceInfoException Class

ORMInterpretationException Class

ORMInvalidFieldReadException Class

ORMLockTimeoutException Class

ORMQueryConstructionException Class

ORMQueryExecutionException Class

ORMRelationException Class

ORMSecurityException Class

ORMSerializationOptimizationException Class

ORMTransientRecoveryFailedException Class

ORMValueTypeMismatchException Class

ParameterFieldRelation Class

ParameterParameterRelation Class

ParameterValue Class

PerformGetDbCountEventArgs Class

PerformGetDbCountEventArgs2 Class

PerformSelectEventArgs Class

PerformSelectEventArgs2 Class

PerformWorkEventArgs Class

PerformWorkEventArgs2 Class

PersistenceCore Class

PersistenceInfoProviderBase Class

PlainSQLFetchAspects Class

PostCollectionChangeAction Enumeration

Predicate Class

PredicateExpression Class

PredicateExpressionElement Class

PredicateExpressionElementType Enumeration

PredicateExpressionOperator Enumeration

PredicateType Enumeration

PredicateWrapper Class

PrefetchPath Class

PrefetchPath2 Class

PrefetchPathElement Class

PrefetchPathElement2 Class

ProjectionLiteral Class

ProjectionRow Class

ProjectionRowProjectorFunc Delegate

ProjectionValueProducerFunc Delegate

QueryApiObjectTraverser Class

QueryFragments Class

QueryParameters Class

RdbmsHint Enumeration

RecoveryDelay Class

RecoveryStrategyBase Class

RecoveryStrategyDelayType Enumeration

ReferencedEntityMap Class

RelationCollection Class

RelationPredicateBucket Class

RelationType Enumeration

ResultsetCache Class

RetrievalQuery Class

RuntimeLibraryVersion Structure

ScalarQueryExpression Class

ScaleOverflowCorrectionAction Enumeration

SchemaNameOverwriteHashtable Class

SchemaNameUsage Enumeration

SequenceRetrievalQuery Class

SerializationHelper Class

SerializationOptimization Enumeration

SerializationReader Class

SerializationUtils Class

SerializationWriter Class

SetOperator Enumeration

Setter Delegate

SimpleRetryRecoveryStrategy Class

SingleDecimalConverter Class

SingleStatementQueryAction Enumeration

SortClause Class

SortExpression Class

SortOperator Enumeration

SourceFieldFinder Class

SqlAzureRecoveryStrategy Class

SqlServerCompatibilityLevel Enumeration

StaticEntityFieldsDataContainer Class

StoredProcedureCall Class

StringBuilderCache Class

StringPlaceHolder Class

SystemTypeConverterBase(T) Class

TableValuedFunctionCall Class

TableValuedFunctionPersistenceInfo Class

TargetEntityFieldPersistenceInfoBucket Class

TemporalTablePredicateType Enumeration

TimedLock Structure

TraceHelper Class

TransactionBase Class

TransactionComPlusBase Class

TypeContainedAttribute Class

TypeConverterDataValueProjector Class

TypedListBase(T) Class

TypedListBase2(T) Class

TypedListCore Class

TypedViewBase(T) Class

UniqueList(T) Class

UniqueValueList(T) Class

UnitOfWork Class

UnitOfWork2 Class

UnitOfWorkBlockType Enumeration

UnitOfWorkCallBackElement Class

UnitOfWorkCallBackElement2 Class

UnitOfWorkCallBackScheduleSlot Enumeration

UnitOfWorkCollectionElement Class

UnitOfWorkCollectionElement2 Class

UnitOfWorkDeleteEntitiesDirectlyElement Class

UnitOfWorkElement Class

UnitOfWorkElement2 Class

UnitOfWorkUpdateEntitiesDirectlyElement Class

UnitOfWorkUpdateMultiElement Class

ValidatorBase Class

ValuePair(TValue1, TValue2) Class

ViewProjectionData(TEntity) Class

VolatileEntityFieldsDataContainer Class

WorkDataCollector Class

XmlExtensionMethods Class

XmlFormatAspect Enumeration

XmlHelper Class

Click or drag to resize

DistinctFilteringPreferenceType Enumeration

Enum which defines the preference type for distinct filtering for select queries.

Namespace: SD.LLBLGen.Pro.ORMSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.2.0.0 (5.2.17.0403)

Syntax

public enum DistinctFilteringPreferenceType

Public Enumeration DistinctFilteringPreferenceType

Members

	Member name	Value	Description
	System	0	Emit Distinct into the SQL query using the rules embedded in the code (default).
	AlwaysClientSide	1	Always use client-side Distinct filtering. This can be CPU intensive with large sets of duplicates, however on databases where DISTINCT is very time consuming, this setting can be an optimization.
	Legacy	2	Use the v2.6 rules set for emitting distinct. Similar to 'System', but with one exception: if the relationships specified contain m:1 or 1:1 relationships, it will see the resultset as 'unique rows' and will use that into account when emitting Distinct and TOP for entity fetches. This option can give wrong results (no distinct emitted while it should emit distinct). In that case, use 'System' (recommended).

See Also

Reference

SD.LLBLGen.Pro.ORMSupportClasses Namespace

(c)2002-2017 Solutions Design bv

Send comments on this topic to LLBLGen Pro v5.2 Runtime Framework Reference Documentation feedback