Click or drag to resize

WindowFunctions Class

Class which defines window (analytical) functions so they can be used within a queryspec query combined with a windowspecification, defined by appending an Over() method call.
Inheritance Hierarchy
SystemObject
  SD.LLBLGen.Pro.QuerySpecWindowFunctions

Namespace:  SD.LLBLGen.Pro.QuerySpec
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.8.0.0 (5.8.21.0111)
Syntax
public class WindowFunctions

The WindowFunctions type exposes the following members.

Constructors
  NameDescription
Public methodWindowFunctions
Initializes a new instance of the WindowFunctions class
Top
Methods
  NameDescription
Public methodStatic memberCumeDist
Creates a CUME_DIST() function call returning a value of type System.Double.
Public methodStatic memberDenseRank
Creates a DENSE_RANK() function call returning value of type System.Int64.
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 methodStatic memberFirstValue
Creates a FIRST_VALUE(scalar_expression) function call returning a value of the type the scalar_expression resolves to.
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodStatic memberLag(Object)
Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Public methodStatic memberLag(Object, Object)
Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Public methodStatic memberLag(Object, Object, Object)
Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Public methodStatic memberLastValue
Creates a LASTVALUE(scalar_expression) function call returning a value of the type the scalar_expression resolves to.
Public methodStatic memberLead(Object)
Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Public methodStatic memberLead(Object, Object)
Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Public methodStatic memberLead(Object, Object, Object)
Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodStatic memberNthValue
Creates a NTH_VALUE(scalar_expression, offset) function call returning a value of the type the scalar_expression resolves to.
Public methodStatic memberNtile
Creates a NTILE(integer_expression) function call returning a value of the type System.Int64.
Public methodStatic memberPercentileCont
Creates a PERCENTILE_CONT(numeric_literal) WITHIN GROUP (ORDER BY orderbyClause) function call returning value of type System.Double.
Public methodStatic memberPercentileDisc
Creates a PERCENTILE_DISC(numeric_literal) WITHIN GROUP (ORDER BY orderbyClause) function call returning value of type System.Double.
Public methodStatic memberPercentRank
Creates a PERCENT_RANK() function call returning value of type System.Double.
Public methodStatic memberRank
Creates a RANK() function call returning value of type System.Int64.
Public methodStatic memberRowNumber
Creates a ROW_NUMBER() function call returning value of type System.Int64.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also