SqlHelper.GetCase Method

Returns statement for the CASE expressions.

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

Syntax

public static string GetCase(
	IEnumerable<KeyValuePair<string, string>> cases,
	string elseCase = null,
	bool escapeString = true
)

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

elseCase (Optional)

Type: System.String
Expression for the else case

escapeString (Optional)

Type: System.Boolean
Determines whether escape cases' values or not

Return Value

Type: String