WindowSpecification Class |
Namespace: SD.LLBLGen.Pro.ORMSupportClasses
The WindowSpecification type exposes the following members.
Name | Description | |
---|---|---|
WindowSpecification |
CTor. Will result in an empty OVER() clause to be emitted.
| |
WindowSpecification(ISortExpression) |
CTor Will result in an OVER(ORDER BY ...) clause to be emitted
| |
WindowSpecification(WindowPartition) |
CTor. Will result in an OVER(PARTITION BY...) clause to be emitted
| |
WindowSpecification(ISortExpression, WindowBounds) |
CTor. Will result in an OVER(ORDER BY ... ROWS/RANGE ...) clause to be emitted
| |
WindowSpecification(WindowPartition, ISortExpression) |
CTor. Will result in an OVER(PARTITION BY ... ORDER BY ...) clause to be emitted
| |
WindowSpecification(WindowPartition, ISortExpression, WindowBounds) |
CTor. Will result in an OVER(PARTITION BY ... ORDER BY ... ROWS/RANGE ...) clause to be emitted
|
Name | Description | |
---|---|---|
DatabaseSpecificCreator |
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.
| |
Parameters |
Gets the list of parameters created during string fragment creation. Only valid after a successful call to ToQueryText
|
Name | Description | |
---|---|---|
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
FrameByRange(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
| |
FrameByRange(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
| |
FrameByRange(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
| |
FrameByRange(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
| |
FrameByRange(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
| |
FrameByRange(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
| |
FrameByRows(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
| |
FrameByRows(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
| |
FrameByRows(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
| |
FrameByRows(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
| |
FrameByRows(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
| |
FrameByRows(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
| |
GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
OrderBy(ISortClause) |
Specifies the sort expression of this instance, overwriting an existing sort expression
| |
OrderBy(ISortExpression) |
Specifies the sort expression of this instance, overwriting an existing sort expression
| |
PartitionBy |
Specifies the Partition of this instance, overwriting an existing partition specification
| |
ToQueryText |
Converts this instance to a string fragment which is used in a select query string.
| |
ToString | Returns a string that represents the current object. (Inherited from Object.) |