Table of Contents

Enum DataMergeMode

Namespace
FluentCommand.Merge
Assembly
FluentCommand.SqlServer.dll

Specifies the strategy for merging data into a target table.

public enum DataMergeMode

Fields

Auto = 0

Automatically determines the best merge mode based on the source data size. If the source contains more than 1000 rows, BulkCopy will be used; otherwise, SqlStatement is used.

BulkCopy = 1

Uses SQL Server bulk copy to insert rows into a temporary table, then merges the data into the target table. This mode is optimized for large data sets.

SqlStatement = 2

Generates and executes a SQL Server MERGE statement to merge the source data directly into the target table. This mode is suitable for smaller data sets or when bulk copy is not desired.