Click or drag to resize

PrefetchPathElement2UseRootMaxLimitAndSorterInPrefetchPathSubQueries Property

The flag to switch on (true) or off (false, default) the usage of the max limit and sorter used to fetch the root of the path in subqueries. If true, the root limit and sorter is added to the subquery filtering on the root entities, which can lead to more optimal queries. Some queries/databases can suffer from this, so only set this to true if required. Default is false, use with care.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.11.0.0 (5.11.23.1114)
Syntax
public bool UseRootMaxLimitAndSorterInPrefetchPathSubQueries { get; set; }

Property Value

Type: Boolean

Implements

IPrefetchPathElementCoreUseRootMaxLimitAndSorterInPrefetchPathSubQueries
Remarks
Setting is ignored for prefetch path elements which are in sub paths
See Also