Class DataMergeGenerator

Namespace

FluentCommand.Merge

Assembly

FluentCommand.SqlServer.dll

Provides static methods to generate SQL statements for data merge operations, including table creation and SQL Server MERGE statements.

public static class DataMergeGenerator

Inheritance

object

DataMergeGenerator

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

CurrentPrefix

The prefix used for current (post-merge) column values in output.

public const string CurrentPrefix = "Current"

Field Value

string

OriginalPrefix

The prefix used for original (pre-merge) column values in output.

public const string OriginalPrefix = "Original"

Field Value

string

TabSize

The number of spaces to use for indentation in generated SQL.

public const int TabSize = 4

Field Value

int

Methods

BuildMerge(DataMergeDefinition)

Builds the SQL Server MERGE statement for the specified merge definition.

public static string BuildMerge(DataMergeDefinition mergeDefinition)

Parameters

mergeDefinition DataMergeDefinition

The DataMergeDefinition describing the merge operation.

Returns

string

The SQL MERGE statement.

BuildMerge(DataMergeDefinition, IDataReader)

Builds the SQL Server MERGE statement for the specified merge definition, optionally using data from an IDataReader.

public static string BuildMerge(DataMergeDefinition mergeDefinition, IDataReader reader)

Parameters

mergeDefinition DataMergeDefinition

The DataMergeDefinition describing the merge operation.

reader IDataReader

An optional IDataReader to provide source data for the merge statement.

Returns

string

The SQL MERGE statement.

BuildTable(DataMergeDefinition)

Builds the SQL statement for creating the temporary table used in the merge operation.

public static string BuildTable(DataMergeDefinition mergeDefinition)

Parameters

mergeDefinition DataMergeDefinition

The DataMergeDefinition describing the temporary table schema.

Returns

string

The SQL statement to create the temporary table.

ParseIdentifier(string)

Removes square bracket quoting from a SQL identifier, if present.

public static string ParseIdentifier(string name)

Parameters

name string

The quoted identifier.

Returns

string

The unquoted identifier.

QuoteIdentifier(string)

Quotes a SQL identifier with square brackets, escaping any closing brackets.

public static string QuoteIdentifier(string name)

Parameters

name string

The identifier to quote.

Returns

string

The quoted identifier.

TableIdentifier(string)

Formats a table or schema-qualified table name as a valid SQL identifier, quoting each part as needed.

public static string TableIdentifier(string name)

Parameters

name string

The table name, optionally schema-qualified (e.g., dbo.TableName).

Returns

string

The quoted table identifier (e.g., [dbo].[TableName]).