Click or drag to resize

ISortClause Interface

Interface definition for a class which forms a single sort clause, thus an order by definition defined for a single IEntityField or IEntityField - IFieldPersistenceInfo combination PersistenceInfo will return the same object when an IEntityField is added to the object. Generic

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 interface ISortClause

The ISortClause type exposes the following members.

Properties
  NameDescription
Public propertyCaseSensitiveCollation
Gets / sets the CaseSensitiveCollation flag. If set to true, the UPPER() function (or db specific equivalent) is applied to the field in the ORDER BY clause. Default: false
Public propertyEmitAliasForExpressionAggregateField
Gets or sets a value indicating whether the alias of the field should be emitted if it has an expression/aggregate or the full field / expression. Default is true. Set to false if the field in this sortclause isn't used in the projection and it has an expression/aggregate assigned to it.
Public propertyFieldToSortCore
IEntityFieldCore to sort on.
Public propertyObjectAlias
Alias for the object the field belongs to. Used to identify which entity to use when the entity is present multiple times in a relation collection. Alias has to match an alias specified in the relation collection or should be left empty if no alias is specified (or no relation collection is used).
Public propertyPersistenceInfo
Persistence information for FieldToSort. Can be a cast of the same object, when an IEntityField is added to this sort clause
Public propertySortOperatorToUse
The sort operator to use for this sort clause
Top
Methods
  NameDescription
Public methodReadXml
Deserializes the object data on the xml reader into this instance
Public methodSetCaseSensitiveCollation
Sets the case sensitive collation flag and returns the sortclause instance for further command chaining
Public methodSetEmitAliasForExpressionAggregateField
Sets the property EmitAliasForExpressionAggregateField to the value specified and returns itself, for command chaining in e.g. QuerySpec.
Public methodWriteXml
Serializes the object as xml to the writer specified.
Top
Extension Methods
  NameDescription
Public Extension MethodCaseInsensitive
Sets the CaseSensitiveCollation flag on the sort clause specified. This will apply the UPPER() function (or db specific equivalent) to the field in the ORDER BY clause.
(Defined by SortClauseProducers.)
Public Extension MethodDontEmitAliasForExpressionAggregateField
Sets the EmitAliasForExpressionAggregateField flag on the sort clause specified to false. The value of the flag indicates whether the alias of the field should be emitted if it has an expression/aggregate or the full field / expression. Using this method sets this flag to false indicating that the field in this sortclause isn't used in the projection and it has an expression/aggregate assigned to it.
(Defined by SortClauseProducers.)
Public Extension MethodThenBy
Appends an ISortClause to an existing ISortClause to form a new ISortExpression
(Defined by SortClauseProducers.)
Top
See Also