SqlHelper.MergeColumns Method (IEnumerable<String>, IEnumerable<String>, Func<String, String>, Boolean, Func<String, String>)

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: System.Collections.Generic.IEnumerable<String>
Original column list

addColumns (Optional)

Type: System.Collections.Generic.IEnumerable<String>
List of columns to add

uniqueKey (Optional)

Type: System.Func<String, String>
Function which provides unique key for the merging process (if two column keys match, the merging process allows only first column)

extraColumns (Optional)

Type: System.Boolean
Indicates if columns which are not part of '*' expression are merged to the existing list of columns

transformation (Optional)

Type: System.Func<String, String>
Column transformation

Return Value

Type: String
Returns the list separated by dashes for use in SQL query