Class QueryColumnSqlFunctions

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Provides extension methods with SQL functions applicable to the QueryColumn object.

[Obsolete("Class was not intended for public use and will be removed.")]
public static class QueryColumnSqlFunctions

Inheritance

object

QueryColumnSqlFunctions

Methods

Cast(QueryColumn, string, int, int)

Applies CAST function to the column.

public static QueryColumn Cast(this QueryColumn column, string dataType, int size = 0, int precision = 0)

Parameters

column QueryColumn

Column used for required function.

dataType string

Data type to which the cast should be done. Use constants defined in FieldDataType class.

size int

Size of the type

precision int

Precision of the type

Returns

QueryColumn

IsNull(QueryColumn, object)

Applies ISNULL function to the column.

public static QueryColumn IsNull(this QueryColumn column, object nullReplacement)

Parameters

column QueryColumn

Column used for required function.

nullReplacement object

Replacement expression used instead of null value. Value must be of a type that is implicitly convertible to the type of the column.

Returns

QueryColumn