SqlHelper.GetCaseColumn Method

Returns statement for column with case expressions. This statement is used for evaluating a set of boolean expressions to determine the result. First case has highest priority.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0

Syntax

public static string GetCaseColumn(
	IEnumerable<KeyValuePair<string, string>> cases,
	string asColumnName = "CaseColumn"
)

Parameters

cases

Type: System.Collections.Generic.IEnumerable<KeyValuePair<String, String>>
IEnumerable with KeyValuePair where key is a boolean expression (where condition) and value is result expression

asColumnName (Optional)

Type: System.String
Specifies column name

Return Value

Type: String