SqlHelper MergeColumns Method (IEnumerable String , IEnumerable String , Func String, String , Boolean, Func String, String )Kentico 8.1 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.1.5347.20411)

Parameters

columns
Type: OnlineSystem.Collections.Generic IEnumerable OnlineString 
Original column list
addColumns (Optional)
Type: OnlineSystem.Collections.Generic IEnumerable OnlineString 
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