Class RowNumberColumn

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Row number query column e.g. "ROW_NUMBER() OVER (ORDER BY DefaultCulture) AS CMS_RN"

public class RowNumberColumn : SelectQueryColumnBase<RowNumberColumn>, IQueryParameters<RowNumberColumn>, IQueryColumn, IQueryExpression, IQueryParameters, IQueryObjectWithValue, IQueryObject

Inheritance

object

AbstractQueryObject

QueryParametersBase<RowNumberColumn>

QueryColumnBase<RowNumberColumn>

SelectQueryColumnBase<RowNumberColumn>

RowNumberColumn

Implements

IQueryParameters<RowNumberColumn>

IQueryColumn

IQueryExpression

IQueryParameters

IQueryObjectWithValue

IQueryObject

Inherited Members

SelectQueryColumnBase<RowNumberColumn>.Name

SelectQueryColumnBase<RowNumberColumn>.ColumnAlias

SelectQueryColumnBase<RowNumberColumn>.EnsureBracketsForAlias

SelectQueryColumnBase<RowNumberColumn>.As(string)

SelectQueryColumnBase<RowNumberColumn>.GetExpression()

QueryColumnBase<RowNumberColumn>.Expression

QueryColumnBase<RowNumberColumn>.TypedThis

QueryColumnBase<RowNumberColumn>.AsAlias()

QueryColumnBase<RowNumberColumn>.WithExpression(string)

QueryColumnBase<RowNumberColumn>.ToString(bool)

QueryColumnBase<RowNumberColumn>.AsValue()

QueryParametersBase<RowNumberColumn>.mParameters

QueryParametersBase<RowNumberColumn>.IsImmutable

QueryParametersBase<RowNumberColumn>.Parameters

QueryParametersBase<RowNumberColumn>.ApplyParametersTo(IQueryObject)

QueryParametersBase<RowNumberColumn>.CopyPropertiesTo(IQueryObject)

QueryParametersBase<RowNumberColumn>.CloneObject()

QueryParametersBase<RowNumberColumn>.Clone()

QueryParametersBase<RowNumberColumn>.EnsureParameters()

QueryParametersBase<RowNumberColumn>.IncludeDataParameters(QueryDataParameters, string)

QueryParametersBase<RowNumberColumn>.Immutable()

QueryParametersBase<RowNumberColumn>.GetTypedQuery()

QueryParametersBase<RowNumberColumn>.Expand(string)

QueryParametersBase<RowNumberColumn>.ToString()

AbstractQueryObject.Changed()

AbstractQueryObject.Reset()

Extension Methods

DataExtensions.With<T>(T, Action<T>)

QueryExtensions.AsLiteral<T>(T)

QueryExtensions.AsValue<T>(T, bool)

Constructors

RowNumberColumn()

Default constructor

public RowNumberColumn()

RowNumberColumn(string)

Constructor

public RowNumberColumn(string orderBy)

Parameters

orderBy string

Order by

RowNumberColumn(string, IQueryColumn)

Constructor

public RowNumberColumn(string columnName, IQueryColumn orderBy)

Parameters

columnName string

Column name

orderBy IQueryColumn

Order by

RowNumberColumn(string, string)

Constructor

public RowNumberColumn(string columnName, string orderBy)

Parameters

columnName string

Column name

orderBy string

Order by

Properties

IsSingleColumn

Returns true if this column represents a single column

public override bool IsSingleColumn { get; }

Property Value

bool

OrderBy

OrderBy expression for the row number

public string OrderBy { get; set; }

Property Value

string

PartitionBy

If set, the row order gets partitioned by specific column(s)

public string PartitionBy { get; set; }

Property Value

string

Methods

GetValueExpression()

Gets the expression for the column data

protected override string GetValueExpression()

Returns

string