SelectConditionInlineLimit Property |
Limit of the number of items for the inline evaluation.
If there are more items than this limit, the where condition is returned in format:
ColumnName IN (SELECT * FROM @List)), where @List is of the following SQL user-defined table types: Type_CMS_IntegerTable, Type_CMS_BigIntTable, Type_CMS_StringTable, Type_CMS_GuidTable
Otherwise, inline format is used:
ColumnName IN (Value1, Value2, ...)
If set to -1, inline format is always used.
Namespace: CMS.DataEngineAssembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntax public int InlineLimit { get; set; }
Property Value
Type:
Int32Remarks The default value depends on CMSDefaultSQLInlineLimit setting, which has a default value of 1000.
See Also