Class WindowQueryFunction
SQL window function.
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public class WindowQueryFunction : QueryFunction, IQueryColumnExpressionConvertible, IQueryColumnExpressionsCollector, ICloneableConstructors
WindowQueryFunction(QueryFunction)
Declaration
public WindowQueryFunction(QueryFunction innerFunction)Parameters
| Type | Name | Description |
|---|---|---|
| QueryFunction | innerFunction |
WindowQueryFunction(QueryFunction, QueryColumnExpression, QueryColumnExpression)
Declaration
public WindowQueryFunction(QueryFunction innerFunction, QueryColumnExpression partitionByExpression = null, QueryColumnExpression orderByExpression = null)Parameters
| Type | Name | Description |
|---|---|---|
| QueryFunction | innerFunction | |
| QueryColumnExpression | partitionByExpression | |
| QueryColumnExpression | orderByExpression |
WindowQueryFunction(QueryFunction, QueryColumnExpression, QueryColumnExpression, OrderDirection)
Declaration
public WindowQueryFunction(QueryFunction innerFunction, QueryColumnExpression partitionByExpression, QueryColumnExpression orderByExpression, OrderDirection orderDirection)Parameters
| Type | Name | Description |
|---|---|---|
| QueryFunction | innerFunction | |
| QueryColumnExpression | partitionByExpression | |
| QueryColumnExpression | orderByExpression | |
| OrderDirection | orderDirection |
WindowQueryFunction(WindowQueryFunction)
Declaration
public WindowQueryFunction(WindowQueryFunction source)Parameters
| Type | Name | Description |
|---|---|---|
| WindowQueryFunction | source |
Properties
InnerFunction
Function to apply.
Declaration
public QueryFunction InnerFunction { get; set; }Property Value
| Type | Description |
|---|---|
| QueryFunction |
OrderByExpression
Order by clause.
Declaration
public QueryColumnExpression OrderByExpression { get; set; }Property Value
| Type | Description |
|---|---|
| QueryColumnExpression |
OrderDirection
Order direction.
Declaration
public OrderDirection OrderDirection { get; set; }Property Value
| Type | Description |
|---|---|
| OrderDirection |
PartitionByExpression
Partition by clause.
Declaration
public QueryColumnExpression PartitionByExpression { get; set; }Property Value
| Type | Description |
|---|---|
| QueryColumnExpression |
Methods
AddQueryColumnExpressions(QueryColumnExpressionCollection)
Declaration
protected override void AddQueryColumnExpressions(QueryColumnExpressionCollection collection)Parameters
| Type | Name | Description |
|---|---|---|
| QueryColumnExpressionCollection | collection |
Overrides
AddUsingParameters(QueryParameterCollection)
Adds given parameters to collection.
Declaration
public override void AddUsingParameters(QueryParameterCollection resultParameters)Parameters
| Type | Name | Description |
|---|---|---|
| QueryParameterCollection | resultParameters | Query parameters collection. |
Overrides
BuildSqlText(StringBuilder, DBEngine)
Build window function sql text.
Declaration
public override void BuildSqlText(StringBuilder sb, DBEngine dbEngine)Parameters
| Type | Name | Description |
|---|---|---|
| System.Text.StringBuilder | sb | string builder. |
| DBEngine | dbEngine | DBEngine instance. |
Overrides
Clone()
Clone current object.
Declaration
public override object Clone()Returns
| Type | Description |
|---|---|
| System.Object |
Overrides
Implements
System.ICloneable