SqlHelperGetCaseColumn 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.DataEngineAssembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 10.0.0
Syntax public static string GetCaseColumn(
IEnumerable<KeyValuePair<string, string>> cases,
string asColumnName = "CaseColumn"
)
Parameters
- cases
- Type: System.Collections.GenericIEnumerableKeyValuePairString, String
IEnumerable with KeyValuePair where key is a boolean expression (where condition) and value is result expression - asColumnName (Optional)
- Type: SystemString
Specifies column name
Return Value
Type:
StringSee Also