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.2.23

Syntax

public static string MergeColumns(
	IEnumerable<string> columns,
	IEnumerable<string> addColumns = null,
	Func<string, string> uniqueKey = null,
	bool extraColumns = true,
	Func<string, string> transformation = null
)

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