SqlHelper MergeColumns Method (String, String, Func String, String , Boolean, Func String, String )Kentico 8.0 API Reference
Merges the sets of columns and makes sure that each column in the result is present only once.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.0.0.0 (8.0.5239.26125)

Parameters

columns
Type: OnlineSystem String
Original column list
addColumns
Type: OnlineSystem String
List of columns to add
uniqueKey (Optional)
Type: OnlineSystem Func OnlineString, OnlineString 
Function which provides unique key for the merging process (if two column keys match, the merging process allows only first column)
extraColumns (Optional)
Type: OnlineSystem Boolean
Indicates if columns which are not part of '*' expression are merged to the existing list of columns
transformation (Optional)
Type: OnlineSystem Func OnlineString, OnlineString 
Column transformation

Return Value

Type: OnlineString
Returns the list separated by dashes for use in SQL query
See Also