Table of Contents

Class BulkOperation

Namespace
Z.BulkOperations
Assembly
Z.EntityFramework.Extensions.dll
public class BulkOperation : IDisposable
Inheritance
BulkOperation
Implements
Derived
Inherited Members

Constructors

BulkOperation() 

public BulkOperation()

BulkOperation(DbConnection) 

public BulkOperation(DbConnection connection)

Parameters

connection DbConnection

Fields

_StreamSize 

public int _StreamSize

Field Value

int

_isDapperPlus 

public bool _isDapperPlus

Field Value

bool

_isLinqToSql 

public bool _isLinqToSql

Field Value

bool

_postConfiguration 

public object _postConfiguration

Field Value

object

Properties

AddLogExecuting

Gets or sets an action to execute every time the log is used.

public Action<object, StringBuilder> AddLogExecuting { get; set; }

Property Value

Action<object, StringBuilder>

The action to execute every time the log is used.

AllowConcurrency

Gets or sets if the operations should check the concurrency token or not.

public bool AllowConcurrency { get; set; }

Property Value

bool

AllowDuplicateKeys

Gets or sets a value indicating whether we allow duplicate kyes.

public bool AllowDuplicateKeys { get; set; }

Property Value

bool

true if allow duplicate kyes, false if not.

AllowUpdatePrimaryKeys

Gets or sets a value indicating whether we allow update primary keys.

public bool AllowUpdatePrimaryKeys { get; set; }

Property Value

bool

true if allow update primary keys, false if not.

AuditEntries

Gets or sets the audit entries.

public List<AuditEntry> AuditEntries { get; set; }

Property Value

List<AuditEntry>

The audit entries.

AuditMode

Gets or sets the audit mode.

public AuditModeType AuditMode { get; set; }

Property Value

AuditModeType

The audit mode.

AutoMap

Gets or sets the automatic map.

public AutoMapType AutoMap { get; set; }

Property Value

AutoMapType

The automatic map.

AutoMapColumnBuilder

Gets or sets the builder to use when a new column AutoMapped is added.

public Action<string, ColumnMapping> AutoMapColumnBuilder { get; set; }

Property Value

Action<string, ColumnMapping>

The builder to use when a new column AutoMapped is added.

AutoMapIdentityExpression

Gets or sets the automatic map identity expression.

public Expression<Func<object, object>> AutoMapIdentityExpression { get; set; }

Property Value

Expression<Func<object, object>>

The automatic map identity expression.

AutoMapIdentityName

Gets or sets the name of the automatic map identity.

public string AutoMapIdentityName { get; set; }

Property Value

string

The name of the automatic map identity.

AutoMapKeyExpression

Gets or sets the automatic map key expression.

public Expression<Func<object, object>> AutoMapKeyExpression { get; set; }

Property Value

Expression<Func<object, object>>

The automatic map key expression.

AutoMapKeyName

Gets or sets the name of the automatic map key.

public string AutoMapKeyName { get; set; }

Property Value

string

The name of the automatic map key.

AutoMapOutputDirection

Gets or sets if value such as identity should be ouputted by default (disable for better performance).

public bool AutoMapOutputDirection { get; set; }

Property Value

bool

AutoMapValueFactory

Gets or sets the factory to use in value when AutoMap is used.

public Func<string, object, object> AutoMapValueFactory { get; set; }

Property Value

Func<string, object, object>

The factory to use in value when AutoMap is used.

AutoTruncate

Gets or sets a value indicating whether string value are automatic truncated.

public bool? AutoTruncate { get; set; }

Property Value

bool?

True if string value are automatic truncated, false if not.

BatchDelayInterval

Gets or sets the batch delay interval.

public int BatchDelayInterval { get; set; }

Property Value

int

The batch delay interval.

BatchDeleteBuilder

Gets or sets the batch delete builder.

public Action<BatchDelete> BatchDeleteBuilder { get; set; }

Property Value

Action<BatchDelete>

BatchSize

Gets or sets the size of the batch.

public int BatchSize { get; set; }

Property Value

int

The size of the batch.

BatchTimeout

Gets or sets the batch timeout.

public int BatchTimeout { get; set; }

Property Value

int

The batch timeout.

BatchUpdateBuilder

Gets or sets the batch update builder.

public Action<BatchUpdate> BatchUpdateBuilder { get; set; }

Property Value

Action<BatchUpdate>

BulkOperationExecuted

Gets or sets the bulk operation executed.

public Action<BulkOperation> BulkOperationExecuted { get; set; }

Property Value

Action<BulkOperation>

The bulk operation executed.

BulkOperationExecuting

Gets or sets the bulk operation executing.

public Action<BulkOperation> BulkOperationExecuting { get; set; }

Property Value

Action<BulkOperation>

The bulk operation executing.

CaseSensitive

Gets or sets the case sensitive mode.

public CaseSensitiveType CaseSensitive { get; set; }

Property Value

CaseSensitiveType

The case sensitive mode.

CoalesceDestinationOnMergeUpdateExpression

Gets or sets columns to coalesce, ISNULL(DestinationValue, StagingValue).

public Expression<Func<object, object>> CoalesceDestinationOnMergeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(DestinationValue, StagingValue).

CoalesceDestinationOnMergeUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(DestinationValue, StagingValue).

public List<string> CoalesceDestinationOnMergeUpdateNames { get; set; }

Property Value

List<string>

CoalesceDestinationOnSynchronizeUpdateExpression

Gets or sets columns to coalesce, ISNULL(DestinationValue, StagingValue).

public Expression<Func<object, object>> CoalesceDestinationOnSynchronizeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(DestinationValue, StagingValue).

CoalesceDestinationOnSynchronizeUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(DestinationValue, StagingValue).

public List<string> CoalesceDestinationOnSynchronizeUpdateNames { get; set; }

Property Value

List<string>

CoalesceDestinationOnUpdateExpression

Gets or sets columns to coalesce, ISNULL(DestinationValue, StagingValue).

public Expression<Func<object, object>> CoalesceDestinationOnUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(DestinationValue, StagingValue).

CoalesceDestinationOnUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(DestinationValue, StagingValue).

public List<string> CoalesceDestinationOnUpdateNames { get; set; }

Property Value

List<string>

CoalesceOnMergeUpdateExpression

Gets or sets columns to coalesce, ISNULL(StagingValue, DestinationValue).

public Expression<Func<object, object>> CoalesceOnMergeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(StagingValue, DestinationValue).

CoalesceOnMergeUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(StagingValue, DestinationValue).

public List<string> CoalesceOnMergeUpdateNames { get; set; }

Property Value

List<string>

CoalesceOnSynchronizeUpdateExpression

Gets or sets columns to coalesce, ISNULL(StagingValue, DestinationValue).

public Expression<Func<object, object>> CoalesceOnSynchronizeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(StagingValue, DestinationValue).

CoalesceOnSynchronizeUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(StagingValue, DestinationValue).

public List<string> CoalesceOnSynchronizeUpdateNames { get; set; }

Property Value

List<string>

CoalesceOnUpdateExpression

Gets or sets columns to coalesce, ISNULL(StagingValue, DestinationValue).

public Expression<Func<object, object>> CoalesceOnUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to coalesce, ISNULL(StagingValue, DestinationValue).

CoalesceOnUpdateNames

Gets or sets a list of property names to use for columns to coalesce, ISNULL(StagingValue, DestinationValue).

public List<string> CoalesceOnUpdateNames { get; set; }

Property Value

List<string>

ColumnInputExpression

Gets or sets the column input expression.

public Expression<Func<object, object>> ColumnInputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The column input expression.

ColumnInputNames

Gets or sets a list of property names to input.

public List<string> ColumnInputNames { get; set; }

Property Value

List<string>

ColumnInputOutputExpression

Gets or sets the column input/output expression.

public Expression<Func<object, object>> ColumnInputOutputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The column input/output expression.

ColumnInputOutputNames

Gets or sets a list of property names to input/output.

public List<string> ColumnInputOutputNames { get; set; }

Property Value

List<string>

ColumnMappings

Gets or sets the column mappings.

public List<ColumnMapping> ColumnMappings { get; set; }

Property Value

List<ColumnMapping>

The column mappings.

ColumnOutputExpression

Gets or sets the column output expression.

public Expression<Func<object, object>> ColumnOutputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The column output expression.

ColumnOutputNames

Gets or sets a list of property names to output.

public List<string> ColumnOutputNames { get; set; }

Property Value

List<string>

ColumnPrimaryKeyExpression

Gets or sets the column primary key expression.

public Expression<Func<object, object>> ColumnPrimaryKeyExpression { get; set; }

Property Value

Expression<Func<object, object>>

The column primary key expression.

ColumnPrimaryKeyNames

Gets or sets a list of property names to use for the primary key.

public List<string> ColumnPrimaryKeyNames { get; set; }

Property Value

List<string>

ColumnStagingTableFormulaExpression

Gets or sets columns that should be added to be used in formula.

public Expression<Func<object, object>> ColumnStagingTableFormulaExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns that should be added to be used in formula.

ColumnStagingTableFormulaNames

Gets or sets a list of property names to use for formula.

public List<string> ColumnStagingTableFormulaNames { get; set; }

Property Value

List<string>

ColumnSynchronizeDeleteKeySubsetExpression

Gets or sets the column synchronize delete key subset expression.

public Expression<Func<object, object>> ColumnSynchronizeDeleteKeySubsetExpression { get; set; }

Property Value

Expression<Func<object, object>>

The column synchronize delete key subset expression.

ColumnSynchronizeDeleteKeySubsetFormula

Gets or sets the column synchronize delete key subset formula (The SQL to make the JOIN statement for the DELETE part of the BulkSynchronize).

public string ColumnSynchronizeDeleteKeySubsetFormula { get; set; }

Property Value

string

The column synchronize delete key subset formula (The SQL to make the JOIN statement for the DELETE part of the BulkSynchronize).

ColumnSynchronizeDeleteKeySubsetNames

Gets or sets a list of property names to use in synchronize delete key subset.

public List<string> ColumnSynchronizeDeleteKeySubsetNames { get; set; }

Property Value

List<string>

CombineMaxCommand

Gets or sets the maximum command that can be combined in a single batch (BulkSaveChanges only, DefaultValue=25).

public int CombineMaxCommand { get; set; }

Property Value

int

The maximum command that can be combined in a single batch (BulkSaveChanges only, DefaultValue=25).

CommandParameterAddRowIndex

Gets or sets a value indicating whether the command parameter add row index.

public bool CommandParameterAddRowIndex { get; set; }

Property Value

bool

true if command parameter add row index, false if not.

CommandParameterPrefix

Gets or sets the command parameter prefix.

public string CommandParameterPrefix { get; set; }

Property Value

string

The command parameter prefix.

CommandParameterSuffix

Gets or sets the command parameter suffix.

public string CommandParameterSuffix { get; set; }

Property Value

string

The command parameter suffix.

Connection

Gets or sets the connection.

public virtual DbConnection Connection { get; set; }

Property Value

DbConnection

The connection.

ConnectionFactory

Gets or sets the connection factory.

public Func<DbConnection> ConnectionFactory { get; set; }

Property Value

Func<DbConnection>

The connection factory.

ConnectionName

Gets or sets the name of the connection.

public string ConnectionName { get; set; }

Property Value

string

The name of the connection.

ConnectionString

Gets or sets the connection string.

public string ConnectionString { get; set; }

Property Value

string

The connection string.

ContextFactory

Gets or sets the context factory function to use when a working context is requested.

public Func<DbContext, DbContext> ContextFactory { get; set; }

Property Value

Func<DbContext, DbContext>

CustomProvider

Gets or sets the custom provider.

public CustomProvider CustomProvider { get; set; }

Property Value

CustomProvider

The custom provider.

DataSource

Gets or sets the data source.

public object DataSource { get; set; }

Property Value

object

The data source.

Debug1

Gets or sets an internal debug (Enable only when ZZZ support info team is asking for it).

public bool Debug1 { get; set; }

Property Value

bool

DefaultValueResolution

Gets or sets the default value resolution.

public DefaultValueResolutionType DefaultValueResolution { get; set; }

Property Value

DefaultValueResolutionType

The default value resolution.

DeleteFromQueryExecuted

Gets or sets the delete from query executed.

public Action<BulkOperation> DeleteFromQueryExecuted { get; set; }

Property Value

Action<BulkOperation>

The delete from query executed.

DeleteMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when delete is matched.

public Expression<Func<object, object>> DeleteMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when delete is matched.

DeleteMatchedAndConditionNames

Gets or sets a list of property names to use in the AND CONDITION when delete is matched.

public List<string> DeleteMatchedAndConditionNames { get; set; }

Property Value

List<string>

DeleteMatchedAndFormula

Gets or sets the formula to add after the "AND" in the delete statement (in the merge part).

public string DeleteMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the delete statement (in the merge part).

DeleteMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when delete is matched.

public Expression<Func<object, object>> DeleteMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when delete is matched.

DeleteMatchedAndOneNotConditionNames

Gets or sets a list of property names to use in the AND (ONE NOT MEET CONDITION) when delete is matched.

public List<string> DeleteMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

DeletePrimaryKeyAndFormula

Gets or sets the formula to add after the "AND" in the delete statement when joining with the key.

public string DeletePrimaryKeyAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the delete statement when joining with the key.

DeleteStagingTableFilterFormula

Gets or sets a SQL Formula to prefilter the staging table for the BulkDelete operation.

public string DeleteStagingTableFilterFormula { get; set; }

Property Value

string

DestinationSchemaName

Gets or sets the name of the destination schema.

public string DestinationSchemaName { get; set; }

Property Value

string

The name of the destination schema.

DestinationTableName

Gets or sets the name of the destination table.

public string DestinationTableName { get; set; }

Property Value

string

The name of the destination table.

DisableDotCheckForEscapeTableName

Gets or sets a value indicating whether the dot check for escape table name is disabled.

public bool DisableDotCheckForEscapeTableName { get; set; }

Property Value

bool

True if disable dot check for escape table name, false if not.

DisableInformationSchemaCache

Gets or sets a value indicating if the InformationSchema cache should be disabled or not.

public bool DisableInformationSchemaCache { get; set; }

Property Value

bool

True if the InformationSchema cache should be disabled.

DisablePrimaryKeyNullCheck

Gets or sets if null check should be disabled when a surrogate keys is used (more than 1 key).

public bool DisablePrimaryKeyNullCheck { get; set; }

Property Value

bool

true if null check should be disabled when a surrogate keys is used (more than 1 key).

DisableSqlBulkCopyDirect

Gets or sets a value indicating whether the bulk copy direct is disabled.

public bool DisableSqlBulkCopyDirect { get; set; }

Property Value

bool

True if disable bulk copy direct, false if not.

DisableStoredProcedure

Gets or sets a value indicating whether the stored procedure logic is disabled.

public bool DisableStoredProcedure { get; set; }

Property Value

bool

True if disable stored procedure logic, false if not.

DisableTemporaryTableClusteredIndex

Gets or sets a value indicating whether the temporary table clustered index creation is disabled. (SQL Server only)

public bool DisableTemporaryTableClusteredIndex { get; set; }

Property Value

bool

True if disable temporary table clustered index creation, false if not.

EntityType

Gets or sets the type of the entity.

public Type EntityType { get; set; }

Property Value

Type

ErrorMode

Gets or sets the error mode.

public ErrorModeType ErrorMode { get; set; }

Property Value

ErrorModeType

The error mode.

Errors

Gets or sets the error objects.

public List<BulkOperationError> Errors { get; set; }

Property Value

List<BulkOperationError>

The error objects.

ForceOutputFromUnmodifiedRow

Gets or sets a value indicating whether unmodified row should also output values (only work with InsertIfNotExists + SQL Server at this moment).

public bool ForceOutputFromUnmodifiedRow { get; set; }

Property Value

bool

ForceRowsAffectedValidation

Gets or sets a value indicating whether the rows affected validation should be forced for BulkSaveChanges in Entity Framework

public bool ForceRowsAffectedValidation { get; set; }

Property Value

bool

ForceSelectOutput

Gets or sets a value indicating whether the select output should be forced.

public bool ForceSelectOutput { get; set; }

Property Value

bool

true if force select output, false if not.

ForceTriggerResolution

Gets or sets a value indicating whether the trigger resolution should be forced.

public bool ForceTriggerResolution { get; set; }

Property Value

bool

True if force trigger resolution, false if not.

ForceUpdateUnmodifiedValues 

public bool? ForceUpdateUnmodifiedValues { get; set; }

Property Value

bool?

HasColumnEncrypted

Gets or sets a value indicating whether this object has column encrypted.

public bool HasColumnEncrypted { get; set; }

Property Value

bool

true if this object has column encrypted, false if not.

IgnoreColumnOutputExpression

Gets or sets columns output to ignore using an expression.

public Expression<Func<object, object>> IgnoreColumnOutputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns output to ignore using an expression.

IgnoreColumnOutputNames

Gets or sets columns output to ignore using names.

public List<string> IgnoreColumnOutputNames { get; set; }

Property Value

List<string>

The columns output to ignore using names.

IgnoreOnDeleteMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when delete is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnDeleteMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when delete is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnDeleteMatchedAndConditionNames

Gets or sets a list of property names to ignore in the AND CONDITION when delete is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnDeleteMatchedAndConditionNames { get; set; }

Property Value

List<string>

IgnoreOnDeleteMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when delete is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnDeleteMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when delete is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnDeleteMatchedAndOneNotConditionNames

Gets or sets a list of property names to ignore in the AND (ONE NOT MEET CONDITION) when delete is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnDeleteMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

IgnoreOnInsertExpression

Gets or sets the ignore on insert expression.

public Expression<Func<object, object>> IgnoreOnInsertExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on insert expression.

IgnoreOnInsertNames

Gets or sets a list of property names to ignore on insert.

public List<string> IgnoreOnInsertNames { get; set; }

Property Value

List<string>

IgnoreOnMergeInsert

Gets or sets a value indicating whether the INSERT will be performed for the Merge method.

public bool IgnoreOnMergeInsert { get; set; }

Property Value

bool

IgnoreOnMergeInsertExpression

Gets or sets the ignore on merge insert expression.

public Expression<Func<object, object>> IgnoreOnMergeInsertExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on merge insert expression.

IgnoreOnMergeInsertNames

Gets or sets a list of property names to ignore on merge insert.

public List<string> IgnoreOnMergeInsertNames { get; set; }

Property Value

List<string>

IgnoreOnMergeMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when merge update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnMergeMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when merge update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnMergeMatchedAndConditionNames

Gets or sets a list of property names to ignore in the AND CONDITION when merge update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnMergeMatchedAndConditionNames { get; set; }

Property Value

List<string>

IgnoreOnMergeMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when merge update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnMergeMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when merge update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnMergeMatchedAndOneNotConditionNames

Gets or sets a list of property names to ignore in the AND (ONE NOT MEET CONDITION) when merge update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnMergeMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

IgnoreOnMergeUpdate

Gets or sets a value indicating whether the UPDATE will be performed for the Merge method.

public bool IgnoreOnMergeUpdate { get; set; }

Property Value

bool

IgnoreOnMergeUpdateExpression

Gets or sets the ignore on merge update expression.

public Expression<Func<object, object>> IgnoreOnMergeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on merge update expression.

IgnoreOnMergeUpdateNames

Gets or sets a list of property names to ignore on merge update.

public List<string> IgnoreOnMergeUpdateNames { get; set; }

Property Value

List<string>

IgnoreOnSynchronizeInsertExpression

Gets or sets the ignore on synchronize insert expression.

public Expression<Func<object, object>> IgnoreOnSynchronizeInsertExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on synchronize insert expression.

IgnoreOnSynchronizeInsertNames

Gets or sets a list of property names to ignore on synchronize insert.

public List<string> IgnoreOnSynchronizeInsertNames { get; set; }

Property Value

List<string>

IgnoreOnSynchronizeMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnSynchronizeMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnSynchronizeMatchedAndConditionNames

Gets or sets a list of property names to ignore in the AND CONDITION when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnSynchronizeMatchedAndConditionNames { get; set; }

Property Value

List<string>

IgnoreOnSynchronizeMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnSynchronizeMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnSynchronizeMatchedAndOneNotConditionNames

Gets or sets a list of property names to ignore in the AND (ONE NOT MEET CONDITION) when synchronize (merge) update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnSynchronizeMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

IgnoreOnSynchronizeUpdateExpression

Gets or sets the ignore on synchronize update expression.

public Expression<Func<object, object>> IgnoreOnSynchronizeUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on synchronize update expression.

IgnoreOnSynchronizeUpdateNames

Gets or sets a list of property names to ignore on synchronize update.

public List<string> IgnoreOnSynchronizeUpdateNames { get; set; }

Property Value

List<string>

IgnoreOnUpdateExpression

Gets or sets the ignore on update expression.

public Expression<Func<object, object>> IgnoreOnUpdateExpression { get; set; }

Property Value

Expression<Func<object, object>>

The ignore on update expression.

IgnoreOnUpdateMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnUpdateMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnUpdateMatchedAndConditionNames

Gets or sets a list of property names to ignore in the AND CONDITION when update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnUpdateMatchedAndConditionNames { get; set; }

Property Value

List<string>

IgnoreOnUpdateMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when update is matched. All columns are part of the condition except those from the ignore expression.

public Expression<Func<object, object>> IgnoreOnUpdateMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when update is matched. All columns are part of the condition except those from the ignore expression.

IgnoreOnUpdateMatchedAndOneNotConditionNames

Gets or sets a list of property names to ignore in the AND (ONE NOT MEET CONDITION) when update is matched. All columns are part of the condition except those from the ignore.

public List<string> IgnoreOnUpdateMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

IgnoreOnUpdateNames

Gets or sets a list of property names to ignore on update.

public List<string> IgnoreOnUpdateNames { get; set; }

Property Value

List<string>

IncludeGraph

Perform a bulk operations by including all the graph (related entities). DO NOT Support BulkDelete and BulkSynchronize.

public bool IncludeGraph { get; set; }

Property Value

bool

IncludeGraphOperationBuilder

Sets an action builder that will build a bulk operations depending on the types (usually used with IncludeGraph or Inheritance).

public Action<BulkOperation> IncludeGraphOperationBuilder { get; set; }

Property Value

Action<BulkOperation>

IncludeJunctionTable

Gets or sets a value indicating whether the junction table should be included for operation such as DeleteFromQuery.

public bool IncludeJunctionTable { get; set; }

Property Value

bool

True the junction table should be included for operation such as DeleteFromQuery.

InsertIfNotExists

Gets or sets a value indicating whether the insert if not exists.

public bool InsertIfNotExists { get; set; }

Property Value

bool

true if insert if not exists, false if not.

InsertKeepIdentity

Gets or sets a value indicating whether the insert keep identity.

public bool InsertKeepIdentity { get; set; }

Property Value

bool

true if insert keep identity, false if not.

InsertNotMatchedAndFormula

Gets or sets the formula to add after the "AND" in the insert (merge) "NOT MATCHED" statement. Using "InsertPrimaryKeyAndFormula" or "InsertStagingTableFilterFormula" is recommanded over this options.

public string InsertNotMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the insert (merge) "NOT MATCHED" statement.

InsertPrimaryKeyAndFormula

Gets or sets the formula to add after the "AND" in the insert statement when joining with the key (WARNING: If the destination table is empty, the condition is always true and rows are always inserted).

public string InsertPrimaryKeyAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the insert statement when joining with the key (WARNING: If the destination table is empty, the condition is always true and rows are always inserted).

InsertStagingTableFilterFormula

Gets or sets a SQL Formula to prefilter the staging table for the BulkInsert operation.

public string InsertStagingTableFilterFormula { get; set; }

Property Value

string

InternalIsEntityFrameworkPlus 

public bool InternalIsEntityFrameworkPlus { get; set; }

Property Value

bool

InternalOptions

Internal Options. DO NOT USE IT.

public InternalOptions InternalOptions { get; set; }

Property Value

InternalOptions

InternalTransaction

Gets or sets the internal transaction.

public InternalTransactionType InternalTransaction { get; set; }

Property Value

InternalTransactionType

The internal transaction.

IsCheckConstraintOnInsertDisabled

Gets or sets is Check Constraint is disabled on Insert. DANGER: This option force a SqlBulkCopy and is incompatible with almost all options.

public bool IsCheckConstraintOnInsertDisabled { get; set; }

Property Value

bool

IsReadOnly

Gets or sets a value indicating whether this object is read only.

public bool IsReadOnly { get; set; }

Property Value

bool

True if this object is read only, false if not.

LambdaCoalesceDestinationOnMergeUpdateExpression 

public LambdaExpression LambdaCoalesceDestinationOnMergeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaCoalesceDestinationOnSynchronizeUpdateExpression 

public LambdaExpression LambdaCoalesceDestinationOnSynchronizeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaCoalesceDestinationOnUpdateExpression 

public LambdaExpression LambdaCoalesceDestinationOnUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaCoalesceOnMergeUpdateExpression 

public LambdaExpression LambdaCoalesceOnMergeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaCoalesceOnSynchronizeUpdateExpression 

public LambdaExpression LambdaCoalesceOnSynchronizeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaCoalesceOnUpdateExpression 

public LambdaExpression LambdaCoalesceOnUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaColumnStagingTableFormulaExpression 

public LambdaExpression LambdaColumnStagingTableFormulaExpression { get; set; }

Property Value

LambdaExpression

LambdaDeleteMatchedAndConditionExpression 

public LambdaExpression LambdaDeleteMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaDeleteMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaDeleteMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreColumnOutputExpression 

public LambdaExpression LambdaIgnoreColumnOutputExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnDeleteMatchedAndConditionExpression 

public LambdaExpression LambdaIgnoreOnDeleteMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnDeleteMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaIgnoreOnDeleteMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnInsertExpression 

public LambdaExpression LambdaIgnoreOnInsertExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnMergeInsertExpression 

public LambdaExpression LambdaIgnoreOnMergeInsertExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnMergeMatchedAndConditionExpression 

public LambdaExpression LambdaIgnoreOnMergeMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnMergeMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaIgnoreOnMergeMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnMergeUpdateExpression 

public LambdaExpression LambdaIgnoreOnMergeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnSynchronizeInsertExpression 

public LambdaExpression LambdaIgnoreOnSynchronizeInsertExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnSynchronizeMatchedAndConditionExpression 

public LambdaExpression LambdaIgnoreOnSynchronizeMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnSynchronizeMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaIgnoreOnSynchronizeMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnSynchronizeUpdateExpression 

public LambdaExpression LambdaIgnoreOnSynchronizeUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaIgnoreOnUpdateExpression 

public LambdaExpression LambdaIgnoreOnUpdateExpression { get; set; }

Property Value

LambdaExpression

LambdaInputExpression 

public LambdaExpression LambdaInputExpression { get; set; }

Property Value

LambdaExpression

LambdaInputOutputExpression 

public LambdaExpression LambdaInputOutputExpression { get; set; }

Property Value

LambdaExpression

LambdaMergeMatchedAndConditionExpression 

public LambdaExpression LambdaMergeMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaMergeMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaMergeMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaOnMergeInsertInputExpression 

public LambdaExpression LambdaOnMergeInsertInputExpression { get; set; }

Property Value

LambdaExpression

LambdaOnMergeUpdateInputExpression 

public LambdaExpression LambdaOnMergeUpdateInputExpression { get; set; }

Property Value

LambdaExpression

LambdaOnSynchronizeInsertInputExpression 

public LambdaExpression LambdaOnSynchronizeInsertInputExpression { get; set; }

Property Value

LambdaExpression

LambdaOnSynchronizeUpdateInputExpression 

public LambdaExpression LambdaOnSynchronizeUpdateInputExpression { get; set; }

Property Value

LambdaExpression

LambdaOutputExpression 

public LambdaExpression LambdaOutputExpression { get; set; }

Property Value

LambdaExpression

LambdaPrimaryKeyExpression 

public LambdaExpression LambdaPrimaryKeyExpression { get; set; }

Property Value

LambdaExpression

LambdaSynchronizeDeleteKeySubsetExpression 

public LambdaExpression LambdaSynchronizeDeleteKeySubsetExpression { get; set; }

Property Value

LambdaExpression

LambdaSynchronizeMatchedAndConditionExpression 

public LambdaExpression LambdaSynchronizeMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaSynchronizeMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaSynchronizeMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaUpdateMatchedAndConditionExpression 

public LambdaExpression LambdaUpdateMatchedAndConditionExpression { get; set; }

Property Value

LambdaExpression

LambdaUpdateMatchedAndOneNotConditionExpression 

public LambdaExpression LambdaUpdateMatchedAndOneNotConditionExpression { get; set; }

Property Value

LambdaExpression

Log

Gets or sets the log.

public Action<string> Log { get; set; }

Property Value

Action<string>

The log.

LogDump

Gets or sets the log dump.

public StringBuilder LogDump { get; set; }

Property Value

StringBuilder

The log dump.

MatchNamesWithUnderscores

Gets or sets if underscore should be ignore for column name. The column "Order_Type" will be mapped to "OrderType" property.

public bool MatchNamesWithUnderscores { get; set; }

Property Value

bool

MergeKeepIdentity

Gets or sets a value indicating whether the merge keep identity.

public bool MergeKeepIdentity { get; set; }

Property Value

bool

true if merge keep identity, false if not.

MergeMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when merge update is matched.

public Expression<Func<object, object>> MergeMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when merge update is matched.

MergeMatchedAndConditionNames

Gets or sets a list of property names to use in the AND CONDITION when merge update is matched.

public List<string> MergeMatchedAndConditionNames { get; set; }

Property Value

List<string>

MergeMatchedAndFormula

Gets or sets the formula to add after the "AND" in the merge statement.

public string MergeMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the merge statement.

MergeMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when merge update is matched.

public Expression<Func<object, object>> MergeMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when merge update is matched.

MergeMatchedAndOneNotConditionNames

Gets or sets a list of property names to use in the AND (ONE NOT MEET CONDITION) when merge update is matched.

public List<string> MergeMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

MergeNotMatchedAndFormula

Gets or sets the formula to add after the "AND" in the merge "NOT MATCHED" statement.

public string MergeNotMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the merge "NOT MATCHED" statement.

MergePrimaryKeyAndFormula

Gets or sets the formula to add after the "AND" in the merge statement when joining with the key (WARNING: If the destination table is empty, the condition is always true and rows are always inserted).

public string MergePrimaryKeyAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the merge statement when joining with the key (WARNING: If the destination table is empty, the condition is always true and rows are always inserted).

MergeStagingTableFilterFormula

Gets or sets a SQL Formula to prefilter the staging table for the BulkMerge operation.

public string MergeStagingTableFilterFormula { get; set; }

Property Value

string

OnMergeInsertInputExpression

Gets or sets columns to input during the Merge Insert statement.

public Expression<Func<object, object>> OnMergeInsertInputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to input during the Merge Insert statement.

OnMergeInsertInputNames

Gets or sets a list of property names to input during the Merge Insert statement.

public List<string> OnMergeInsertInputNames { get; set; }

Property Value

List<string>

OnMergeUpdateInputExpression

Gets or sets columns to input during the Merge Update statement.

public Expression<Func<object, object>> OnMergeUpdateInputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to input during the Merge Update statement.

OnMergeUpdateInputNames

Gets or sets a list of property names to input during the Merge Update statement.

public List<string> OnMergeUpdateInputNames { get; set; }

Property Value

List<string>

OnMergeUpdateUseCoalesce

Gets or sets a value indicating whether the on merge update use coalesce.

public bool OnMergeUpdateUseCoalesce { get; set; }

Property Value

bool

True if on merge update use coalesce, false if not.

OnMergeUpdateUseCoalesceDestination

Gets or sets a value indicating whether the on merge update use coalesce for destination.

public bool OnMergeUpdateUseCoalesceDestination { get; set; }

Property Value

bool

True if on merge update use coalesce for destination, false if not.

OnSynchronizeInsertInputExpression

Gets or sets columns to input during the Synchronize Insert statement.

public Expression<Func<object, object>> OnSynchronizeInsertInputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to input during the Synchronize Insert statement.

OnSynchronizeInsertInputNames

Gets or sets a list of property names to input during the Synchronize Insert statement.

public List<string> OnSynchronizeInsertInputNames { get; set; }

Property Value

List<string>

OnSynchronizeUpdateInputExpression

Gets or sets columns to input during the Synchronize Update statement.

public Expression<Func<object, object>> OnSynchronizeUpdateInputExpression { get; set; }

Property Value

Expression<Func<object, object>>

The columns to input during the Synchronize Update statement.

OnSynchronizeUpdateInputNames

Gets or sets a list of property names to input during the Synchronize Update statement.

public List<string> OnSynchronizeUpdateInputNames { get; set; }

Property Value

List<string>

OnSynchronizeUpdateUseCoalesce

Gets or sets a value indicating whether the on synchronize update use coalesce.

public bool OnSynchronizeUpdateUseCoalesce { get; set; }

Property Value

bool

True if on synchronize update use coalesce, false if not.

OnSynchronizeUpdateUseCoalesceDestination

Gets or sets a value indicating whether the on synchronize update use coalesce for destination.

public bool OnSynchronizeUpdateUseCoalesceDestination { get; set; }

Property Value

bool

True if on synchronize update use coalesce for destination, false if not.

OnUpdateUseCoalesce

Gets or sets a value indicating whether the on update use coalesce.

public bool OnUpdateUseCoalesce { get; set; }

Property Value

bool

True if on update use coalesce, false if not.

OnUpdateUseCoalesceDestination

Gets or sets a value indicating whether the on update use coalesce for destination.

public bool OnUpdateUseCoalesceDestination { get; set; }

Property Value

bool

True if on update use coalesce for destination, false if not.

ParallelBatchByTask

Gets or sets the parallel batch by task.

public int ParallelBatchByTask { get; set; }

Property Value

int

The parallel batch by task.

ParallelMinBatch

Gets or sets the parallel minimum batch.

public int ParallelMinBatch { get; set; }

Property Value

int

The parallel minimum batch.

ParallelMinRecord

Gets or sets the parallel minimum record.

public int ParallelMinRecord { get; set; }

Property Value

int

The parallel minimum record.

PostConfiguration

Gets or sets an action that will be execute once basic options on the BulkOperations has been added such as DestinationTableName, ColumnMapping.

public Action<BulkOperation> PostConfiguration { get; set; }

Property Value

Action<BulkOperation>

Provider

Gets or sets the provider.

public ProviderType Provider { get; set; }

Property Value

ProviderType

The provider.

ProviderAssembly

Gets or sets the provider assembly.

public Assembly ProviderAssembly { get; set; }

Property Value

Assembly

The provider assembly.

QueryHint

Gets or sets a query hint for SQL Server only. The full options text must be set such as OPTION (LOOP JOIN).

public string QueryHint { get; set; }

Property Value

string

Resolution

Gets or sets the resolution mode.

public ResolutionType Resolution { get; set; }

Property Value

ResolutionType

The resolution mode.

ResultInfo

Gets or sets information describing the result.

public ResultInfo ResultInfo { get; set; }

Property Value

ResultInfo

Information describing the result.

RetryCount

Gets or sets the number of retries.

public int RetryCount { get; set; }

Property Value

int

The number of retries.

RetryInterval

Gets or sets the retry interval.

public TimeSpan RetryInterval { get; set; }

Property Value

TimeSpan

The retry interval.

RowsAffected

Gets or sets the number of row affected by the last query.

public int RowsAffected { get; set; }

Property Value

int

The number of row affected by the last query.

SkipPropagationAndAcceptChanges

Gets or sets a value indicating whether all propagation and accept changes must be skipped.

public bool SkipPropagationAndAcceptChanges { get; set; }

Property Value

bool

True if skip propagation and accept changes, false if not.

SqlBulkCopyOptions

Gets or sets the provider.

public int? SqlBulkCopyOptions { get; set; }

Property Value

int?

The provider.

StopwatchForSqlExecutingTime

Gets or sets the stopwatch to calculate the SQL executing time.

public Stopwatch StopwatchForSqlExecutingTime { get; set; }

Property Value

Stopwatch

The stopwatch to calculate the SQL executing time.

StreamSize

Gets or sets the size of the stream.

public int StreamSize { get; set; }

Property Value

int

The size of the stream.

SynchronizeDeleteDestinationTableFilterFormula

Gets or sets the formula to use to filter the DestinationTable (Only for BulkSynchronize during the Delete phase | Support SQL Server only).

public string SynchronizeDeleteDestinationTableFilterFormula { get; set; }

Property Value

string

SynchronizeIgnoreInsert

Gets or sets a value indicating whether the synchronize ignore the insert part.

public bool SynchronizeIgnoreInsert { get; set; }

Property Value

bool

True if synchronize ignore the insert part, false if not.

SynchronizeIgnoreUpdate

Gets or sets a value indicating whether the synchronize ignore the update part.

public bool SynchronizeIgnoreUpdate { get; set; }

Property Value

bool

True if synchronize ignore the update part, false if not.

SynchronizeKeepidentity

Gets or sets a value indicating whether the synchronize keep identity.

public bool SynchronizeKeepidentity { get; set; }

Property Value

bool

true if synchronize keep identity, false if not.

SynchronizeMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when synchronize (merge) update is matched.

public Expression<Func<object, object>> SynchronizeMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when synchronize (merge) update is matched.

SynchronizeMatchedAndConditionNames

Gets or sets a list of property names to use in the AND CONDITION when synchronize (merge) update is matched.

public List<string> SynchronizeMatchedAndConditionNames { get; set; }

Property Value

List<string>

SynchronizeMatchedAndFormula

Gets or sets the formula to add after the "AND" in the synchronize (merge) statement.

public string SynchronizeMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the synchronize (merge) statement.

SynchronizeMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when synchronize (merge) update is matched.

public Expression<Func<object, object>> SynchronizeMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when synchronize (merge) update is matched.

SynchronizeMatchedAndOneNotConditionNames

Gets or sets a list of property names to use in the AND (ONE NOT MEET CONDITION) when synchronize (merge) update is matched.

public List<string> SynchronizeMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

SynchronizeNotMatchedAndFormula

Gets or sets the formula to add after the "AND" in the synchronize (merge) "NOT MATCHED" statement.

public string SynchronizeNotMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the synchronize (merge) "NOT MATCHED" statement.

SynchronizeOnlyDelete

Gets or sets a value indicating whether the synchronize operation should only do the delete part.

public bool SynchronizeOnlyDelete { get; set; }

Property Value

bool

true if the synchronize operation should only do the delete part, false if not.

SynchronizePrimaryKeyAndFormulaDelete

Gets or sets the formula to add after the "AND" in the delete statement when joining with the key (Use 'SynchronizePrimaryKeyAndFormulaMerge' for INSERT/UPDATE).

public string SynchronizePrimaryKeyAndFormulaDelete { get; set; }

Property Value

string

The formula to add after the "AND" in the delete statement when joining with the key (Use 'SynchronizePrimaryKeyAndFormulaMerge' for INSERT/UPDATE).

SynchronizePrimaryKeyAndFormulaMerge

Gets or sets the formula to add after the "AND" in the merge statement when joining with the key (Use 'SynchronizePrimaryKeyAndFormulaDelete' for the DELETE).

public string SynchronizePrimaryKeyAndFormulaMerge { get; set; }

Property Value

string

The formula to add after the "AND" in the merge statement when joining with the key (Use 'SynchronizePrimaryKeyAndFormulaDelete' for the DELETE).

SynchronizeSoftDeleteFormula

Gets or sets the synchronize soft delete SQL formula that replace the DELETE statement.

public string SynchronizeSoftDeleteFormula { get; set; }

Property Value

string

The synchronize soft delete SQLformula that replace the DELETE statement.

TableHintSql

Gets or sets the table hint SQL to use (SQL Server only).

public string TableHintSql { get; set; }

Property Value

string

The table hint SQL to use (SQL Server only).

TemporaryTableBatchByTable

Gets or sets the temporary table batch by table.

public int TemporaryTableBatchByTable { get; set; }

Property Value

int

The temporary table batch by table.

TemporaryTableCreate

Gets or sets a value indicating whether the temporary table should be created by our library when specifying a "TemporaryTableName".

public bool TemporaryTableCreate { get; set; }

Property Value

bool

True if the temporary table should be created by our library when specifying a "TemporaryTableName".

TemporaryTableInsertBatchSize

Gets or sets the size of the temporary table insert batch.

public int TemporaryTableInsertBatchSize { get; set; }

Property Value

int

The size of the temporary table insert batch.

TemporaryTableIsMemory

Gets or sets a value indicating whether the temporary table is memory.

public bool TemporaryTableIsMemory { get; set; }

Property Value

bool

True if temporary table is memory, false if not.

TemporaryTableMinRecord

Gets or sets the temporary table minimum record.

public int TemporaryTableMinRecord { get; set; }

Property Value

int

The temporary table minimum record.

TemporaryTableName

Gets or sets the name of the temporary table.

public string TemporaryTableName { get; set; }

Property Value

string

The name of the temporary table.

TemporaryTablePersist

Gets or sets a value indicating whether the temporary table persist.

public bool TemporaryTablePersist { get; set; }

Property Value

bool

True if temporary table persist, false if not.

TemporaryTableSchemaName

Gets or sets the name of the temporary table schema.

public string TemporaryTableSchemaName { get; set; }

Property Value

string

The name of the temporary table schema.

TemporaryTableUseSameName

Gets or sets a value indicating whether the temporary table should use the same name for every bulk operation with the same destination table.

public bool TemporaryTableUseSameName { get; set; }

Property Value

bool

True if temporary table should use the same name for every bulk operation with the same destination table.

TemporaryTableUseTableLock

Gets or sets a value indicating whether the temporary table use table is locked.

public bool TemporaryTableUseTableLock { get; set; }

Property Value

bool

true if temporary table use table lock, false if not.

TestExecuteAsync

For internal/experience usage only.

public bool TestExecuteAsync { get; set; }

Property Value

bool

Transaction

Gets or sets the transaction.

public DbTransaction Transaction { get; set; }

Property Value

DbTransaction

The transaction.

TransactionIsolationLevel

Gets or sets the transaction isolation level.

public IsolationLevel? TransactionIsolationLevel { get; set; }

Property Value

IsolationLevel?

The transaction isolation level.

UnsafeMode

Gets or sets a value indicating whether the unsafe mode is activated.

public bool UnsafeMode { get; set; }

Property Value

bool

True if unsafe mode, false if not.

UpdateMatchedAndConditionExpression

Gets or sets the AND CONDITION to add when update is matched.

public Expression<Func<object, object>> UpdateMatchedAndConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND CONDITION to add when update is matched.

UpdateMatchedAndConditionNames

Gets or sets a list of property names to use in the AND CONDITION when update is matched.

public List<string> UpdateMatchedAndConditionNames { get; set; }

Property Value

List<string>

UpdateMatchedAndFormula

Gets or sets the formula to add after the "AND" in the update statement (in the merge part).

public string UpdateMatchedAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the update statement (in the merge part).

UpdateMatchedAndOneNotConditionExpression

Gets or sets the AND (ONE NOT MEET CONDITION) to add when update is matched.

public Expression<Func<object, object>> UpdateMatchedAndOneNotConditionExpression { get; set; }

Property Value

Expression<Func<object, object>>

The AND (ONE NOT MEET CONDITION) to add when update is matched.

UpdateMatchedAndOneNotConditionNames

Gets or sets a list of property names to use in the AND (ONE NOT MEET CONDITION) when update is matched.

public List<string> UpdateMatchedAndOneNotConditionNames { get; set; }

Property Value

List<string>

UpdatePrimaryKeyAndFormula

Gets or sets the formula to add after the "AND" in the update statement when joining with the key.

public string UpdatePrimaryKeyAndFormula { get; set; }

Property Value

string

The formula to add after the "AND" in the update statement when joining with the key.

UpdateStagingTableFilterFormula

Gets or sets a SQL Formula to prefilter the staging table for the BulkUpdate operation.

public string UpdateStagingTableFilterFormula { get; set; }

Property Value

string

UseAudit

Gets or sets a value indicating whether this object use audit.

public bool UseAudit { get; set; }

Property Value

bool

true if use audit, false if not.

UseCompile

Gets or sets a value indicating whether this object use compile.

public bool UseCompile { get; set; }

Property Value

bool

true if use compile, false if not.

UseInternalTransaction

Gets or sets a value indicating whether this object use internal transaction.

public bool UseInternalTransaction { get; set; }

Property Value

bool

UseLegacyBatchOperation

Gets or sets a value indicating whether this object use legacy batch operation (Logic used before v6.x)

public bool UseLegacyBatchOperation { get; set; }

Property Value

bool

True if use legacy batch operation (Logic used before v6.x), false if not.

UseLogDump

Gets or sets a value indicating whether this object use log dump.

public bool UseLogDump { get; set; }

Property Value

bool

true if use log dump, false if not.

UseOracleGlobalSequenceIndexTable

Gets or sets a value indicating whether this object use oracle global identity index table.

public bool UseOracleGlobalSequenceIndexTable { get; set; }

Property Value

bool

true if use oracle global identity index table, false if not.

UseParallel

Gets or sets a value indicating whether this object use parallel.

public bool UseParallel { get; set; }

Property Value

bool

true if use parallel, false if not.

UsePermanentTable

Gets or sets if the code should use permanent table instead of temporary table.

public bool UsePermanentTable { get; set; }

Property Value

bool

if the code should use permanent table instead of temporary table.

UsePostgreSqlGetInformationSchema2

Gets or sets a value indicating whether we should directly use the PostgreSQL faillack to retrieve schema information

public bool UsePostgreSqlGetInformationSchema2 { get; set; }

Property Value

bool

UsePostgreSqlInsertOnConflictDoNothing

Gets or sets a value indicating whether instead of checking with the primary key, the SQL generated should do "ON CONFLICT (key) DO NOTHING"

public bool UsePostgreSqlInsertOnConflictDoNothing { get; set; }

Property Value

bool

UsePostgreSqlTimeZone

Gets or sets a value indicating whether this object use PostgreSQL time zone.

public bool UsePostgreSqlTimeZone { get; set; }

Property Value

bool

UsePostgreSqlUnprepare

Gets or sets a value indicating whether the Unprepare() method should be called for every PostgreSQL command.

public bool UsePostgreSqlUnprepare { get; set; }

Property Value

bool

True if the Unprepare() method should be called for every PostgreSQL command.

UseRowsAffected

Gets or sets if the RowAffected should be returned in the ResultInfo (will make the bulk operation slower).

public bool UseRowsAffected { get; set; }

Property Value

bool

True if the RowAffected should be returned in the ResultInfo (will make the bulk operation slower).

UseSmartMatchNames

Gets or sets if underscore, dot, and space should be ignored when matching the column name. This option is an upgrade from MatchNamesWithUnderscores for backward compatibility.

public bool UseSmartMatchNames { get; set; }

Property Value

bool

True if underscore, dot, and space should be ignored when matching the column name. This option is an upgrade from MatchNamesWithUnderscores for backward compatibility.

UseStopwatchForSqlExecutingTime

Gets or sets a value indicating whether a stopwatch should be used to calculate the SQL executing time.

public bool UseStopwatchForSqlExecutingTime { get; set; }

Property Value

bool

True if a stopwatch should be used to calculate the SQL executing time, false if not.

UseTableLock

Gets or sets a value indicating whether the destination table should be locked.

public bool UseTableLock { get; set; }

Property Value

bool

true if the destination table should be locked.

UseTempDbForColumnEncrypted

Gets or sets if the tempdb should be used to solve column encrypted resolution (false by default).

public bool UseTempDbForColumnEncrypted { get; set; }

Property Value

bool

true if the tempdb should be used to solve column encrypted resolution (false by default).

ValidateAllDestinationMapped

Gets or sets a value indicating whether or not to validate all destination columns are mapped.

public bool ValidateAllDestinationMapped { get; set; }

Property Value

bool

True if validate all destination columns are mapped, false if not.

ValidateAllSourceMapped

Gets or sets a value indicating whether or not to validate all source members are mapped.

public bool ValidateAllSourceMapped { get; set; }

Property Value

bool

True if validate all source members are mapped, false if not.

ValidateNoDuplicateKey

Gets or sets a value indicating if the library should check first if there is no duplicate key

public bool ValidateNoDuplicateKey { get; set; }

Property Value

bool

Methods

BulkDelete()

Bulk delete.

public virtual void BulkDelete()

BulkDelete(DataTable, DataRowState)

Bulk delete.

public virtual void BulkDelete(DataTable datasource, DataRowState dataRowState)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

BulkDelete(object)

Bulk delete.

public virtual void BulkDelete(object datasource)

Parameters

datasource object

The datasource.

BulkDeleteAsync(DataTable, DataRowState, CancellationToken)

Bulk delete.

public virtual Task BulkDeleteAsync(DataTable datasource, DataRowState dataRowState, CancellationToken cancellationToken = default)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkDeleteAsync(object, CancellationToken)

Bulk delete.

public virtual Task BulkDeleteAsync(object datasource, CancellationToken cancellationToken = default)

Parameters

datasource object

The datasource.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkDeleteAsync(CancellationToken)

Bulk delete.

public virtual Task BulkDeleteAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkInsert()

Bulk insert.

public virtual void BulkInsert()

Examples

text

var x = 1+2

BulkInsert(DataTable, DataRowState)

Bulk insert.

public virtual void BulkInsert(DataTable datasource, DataRowState dataRowState)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

Examples

text

var x = 1+2
var x = 1+4

text2

var x = 1+3

text 4

BulkInsert(object)

Bulk insert.

public virtual void BulkInsert(object datasource)

Parameters

datasource object

The datasource.

Examples

text

var x = 1+2

text2

var x = 1+3

BulkInsertAsync(DataTable, DataRowState, CancellationToken)

Bulk insert.

public virtual Task BulkInsertAsync(DataTable datasource, DataRowState dataRowState, CancellationToken cancellationToken = default)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkInsertAsync(object, CancellationToken)

Bulk insert.

public virtual Task BulkInsertAsync(object datasource, CancellationToken cancellationToken = default)

Parameters

datasource object

The datasource.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkInsertAsync(CancellationToken)

Bulk insert.

public virtual Task BulkInsertAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkMerge()

Bulk merge.

public virtual void BulkMerge()

BulkMerge(DataTable, DataRowState)

Bulk merge.

public virtual void BulkMerge(DataTable datasource, DataRowState dataRowState)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

BulkMerge(object)

Bulk merge.

public virtual void BulkMerge(object datasource)

Parameters

datasource object

The datasource.

BulkMergeAsync(DataTable, DataRowState, CancellationToken)

Bulk merge.

public virtual Task BulkMergeAsync(DataTable datasource, DataRowState dataRowState, CancellationToken cancellationToken = default)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkMergeAsync(object, CancellationToken)

Bulk merge.

public virtual Task BulkMergeAsync(object datasource, CancellationToken cancellationToken = default)

Parameters

datasource object

The datasource.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkMergeAsync(CancellationToken)

Bulk merge.

public virtual Task BulkMergeAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkSaveChanges(DataTable)

Bulk save changes.

public virtual void BulkSaveChanges(DataTable dt)

Parameters

dt DataTable

The datatable.

BulkSaveChangesAsync(DataTable, CancellationToken)

Bulk save changes.

public virtual Task BulkSaveChangesAsync(DataTable dt, CancellationToken cancellationToken = default)

Parameters

dt DataTable

The datatable.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkSynchronize()

Bulk synchronize.

public virtual void BulkSynchronize()

BulkSynchronize(object)

Bulk synchronize.

public virtual void BulkSynchronize(object datasource)

Parameters

datasource object

The datasource.

BulkSynchronizeAsync(object, CancellationToken)

Bulk synchronize.

public virtual Task BulkSynchronizeAsync(object datasource, CancellationToken cancellationToken = default)

Parameters

datasource object

The datasource.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkSynchronizeAsync(CancellationToken)

Bulk synchronize.

public virtual Task BulkSynchronizeAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkUpdate()

Bulk update.

public virtual void BulkUpdate()

BulkUpdate(DataTable, DataRowState)

Bulk update.

public virtual void BulkUpdate(DataTable datasource, DataRowState dataRowState)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

BulkUpdate(object)

Bulk update.

public virtual void BulkUpdate(object datasource)

Parameters

datasource object

The datasource.

BulkUpdateAsync(DataTable, DataRowState, CancellationToken)

Bulk update.

public virtual Task BulkUpdateAsync(DataTable datasource, DataRowState dataRowState, CancellationToken cancellationToken = default)

Parameters

datasource DataTable

The datasource.

dataRowState DataRowState

State of the data row.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkUpdateAsync(object, CancellationToken)

Bulk update.

public virtual Task BulkUpdateAsync(object datasource, CancellationToken cancellationToken = default)

Parameters

datasource object

The datasource.

cancellationToken CancellationToken

The cancellation token.

Returns

Task

BulkUpdateAsync(CancellationToken)

Bulk update.

public virtual Task BulkUpdateAsync(CancellationToken cancellationToken = default)

Parameters

cancellationToken CancellationToken

The cancellation token.

Returns

Task

Cache(string, BulkOperation) 

public static void Cache(string key, BulkOperation operation)

Parameters

key string
operation BulkOperation

Dispose() 

public void Dispose()

GetFromCache(string) 

public static BulkOperation GetFromCache(string key)

Parameters

key string

Returns

BulkOperation

GetFromCache<T>(string) 

public static T GetFromCache<T>(string key) where T : BulkOperation

Parameters

key string

Returns

T

Type Parameters

T

Recompile()

Recompiles this object.

public void Recompile()

RemoveFromCache(string) 

public static void RemoveFromCache(string key)

Parameters

key string