Class DataMergeColumn

Namespace

FluentCommand.Merge

Assembly

FluentCommand.SqlServer.dll

Represents a mapping between a source and target column for a data merge operation.

public class DataMergeColumn

Inheritance

object

DataMergeColumn

Inherited Members

object.GetType()

object.MemberwiseClone()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

DataMergeColumn()

Initializes a new instance of the DataMergeColumn class with default settings.

public DataMergeColumn()

Remarks

By default, CanInsert, CanUpdate, and CanBulkCopy are set to true.

Properties

CanBulkCopy

Gets or sets a value indicating whether the column is included in the bulk copy operation.

public bool CanBulkCopy { get; set; }

Property Value

bool

true if the column is included in bulk copy; otherwise, false. Default is true.

CanInsert

Gets or sets a value indicating whether the column can be inserted into the target table.

public bool CanInsert { get; set; }

Property Value

bool

true if the column can be inserted; otherwise, false. Default is true.

CanUpdate

Gets or sets a value indicating whether the column can be updated in the target table.

public bool CanUpdate { get; set; }

Property Value

bool

true if the column can be updated; otherwise, false. Default is true.

IsIgnored

Gets or sets a value indicating whether the column is ignored and not used in the merge operation.

public bool IsIgnored { get; set; }

Property Value

bool

true if the column is ignored; otherwise, false.

IsKey

Gets or sets a value indicating whether the column is used as part of the key for the merge operation.

public bool IsKey { get; set; }

Property Value

bool

true if the column is part of the merge key; otherwise, false.

NativeType

Gets or sets the SQL Server native data type for the SourceColumn.

public string NativeType { get; set; }

Property Value

string

The SQL Server native data type (e.g., nvarchar(100), int).

SourceColumn

Gets or sets the name of the source column used to read from the source data. This name is also used in the temporary table during the merge operation.

public string SourceColumn { get; set; }

Property Value

string

The name of the source column.

TargetColumn

Gets or sets the name of the target column in the destination table.

public string TargetColumn { get; set; }

Property Value

string

The name of the target column.

Methods

ToString()

Returns a string that represents the current DataMergeColumn instance.

public override string ToString()

Returns

string

A string containing the source column, target column, native type, key status, and ignored status.