Click or drag to resize

WindowSpecification Class

Class to define a window for an OVER() clause in a select query.
Inheritance Hierarchy
SystemObject
  SD.LLBLGen.Pro.ORMSupportClassesWindowSpecification

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.10.0.0 (5.10.0)
Syntax
[SerializableAttribute]
public class WindowSpecification

The WindowSpecification type exposes the following members.

Constructors
  NameDescription
Public methodWindowSpecification
CTor. Will result in an empty OVER() clause to be emitted.
Public methodWindowSpecification(ISortExpression)
CTor Will result in an OVER(ORDER BY ...) clause to be emitted
Public methodWindowSpecification(WindowPartition)
CTor. Will result in an OVER(PARTITION BY...) clause to be emitted
Public methodWindowSpecification(ISortExpression, WindowBounds)
CTor. Will result in an OVER(ORDER BY ... ROWS/RANGE ...) clause to be emitted
Public methodWindowSpecification(WindowPartition, ISortExpression)
CTor. Will result in an OVER(PARTITION BY ... ORDER BY ...) clause to be emitted
Public methodWindowSpecification(WindowPartition, ISortExpression, WindowBounds)
CTor. Will result in an OVER(PARTITION BY ... ORDER BY ... ROWS/RANGE ...) clause to be emitted
Top
Properties
  NameDescription
Public propertyDatabaseSpecificCreator
Object which will be used to create valid parameter objects, field names, including prefix/postfix characters, and conversion routines, and field names, including prefix/postfix characters. Uses the strategy pattern so the generic code can work with more than one target database.
Public propertyParameters
Gets the list of parameters created during string fragment creation. Only valid after a successful call to ToQueryText
Top
Methods
  NameDescription
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodFrameByRange(Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame from startBound PRECEDING to CURRENT ROW, using the RANGE clause
Public methodFrameByRange(FrameStartBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame from startBound to CURRENT ROW, using the RANGE clause
Public methodFrameByRange(Int32, FrameEndBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound PRECEDING AND endbound, using the RANGE clause
Public methodFrameByRange(Int32, Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound PRECEDING AND endbound FOLLOWING, using the RANGE clause
Public methodFrameByRange(FrameStartBound, FrameEndBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound AND endbound , using the RANGE clause
Public methodFrameByRange(FrameStartBound, Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound AND endbound FOLLOWING, using the RANGE clause
Public methodFrameByRows(Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame from startBound PRECEDING to CURRENT ROW, using the ROWS clause
Public methodFrameByRows(FrameStartBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame from startBound to CURRENT ROW, using the ROWS clause
Public methodFrameByRows(Int32, FrameEndBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound PRECEDING AND endbound, using the ROWS clause
Public methodFrameByRows(Int32, Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound PRECEDING AND endbound FOLLOWING, using the ROWS clause
Public methodFrameByRows(FrameStartBound, FrameEndBound)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound AND endbound , using the ROWS clause
Public methodFrameByRows(FrameStartBound, Int32)
Specifies the window bounds of this instance, overwriting an existing window bounds definition. Defines a frame BETWEEN startBound AND endbound FOLLOWING, using the ROWS clause
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOrderBy(ISortClause)
Specifies the sort expression of this instance, overwriting an existing sort expression
Public methodOrderBy(ISortExpression)
Specifies the sort expression of this instance, overwriting an existing sort expression
Public methodPartitionBy
Specifies the Partition of this instance, overwriting an existing partition specification
Public methodToQueryText
Converts this instance to a string fragment which is used in a select query string.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also