SqlHelper.GetWhereCondition<T> Method (String, IEnumerable<String>, Boolean, Boolean)

Creates the where condition for the array of values.

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

Syntax

public static string GetWhereCondition<T>(
	string columnName,
	IEnumerable<string> values,
	bool useUnicode,
	bool negation = false
)

Parameters

columnName

Type: System.String
Column name

values

Type: System.Collections.Generic.IEnumerable<String>
Values

useUnicode

Type: System.Boolean
Indicates if the preposition 'N' should be used for string values

negation (Optional)

Type: System.Boolean
Indicates if NOT IN should be used

Type Parameters

T

Value type

Return Value

Type: String