Class MergeBulkOptions<T>

Determines the cache mode. Default is Full. If set to Partial, only data that is needed to process the current batch is loaded from the destination table. This will slow down execution performance, but memory consumption may decrease. If MergeMode is set to Full, this setting is ignored (Full is used)

Declaration

{{< /rawhtml >}} ```C# public CacheMode CacheMode { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
CacheMode

CompareColumns

Define properties to check for equality during merge to decide if an update is needed.

Declaration

{{< /rawhtml >}} ```C# public ICollection CompareColumns { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<CompareColumn>

CompareFunc

By default, the CompareColumns are used to determine if a row needs to be updated. You can override the matching behavior using your own compare function which takes the current row and the row from the destination table as input and returns true if the rows are equal (no update), and false if the destination row should be updated. You still need to define the CompareColumns to specify which columns should be retrieved from the destination table.

Declaration

{{< /rawhtml >}} ```C# public Func CompareFunc { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
Func<object, object, bool>

DeleteColumns

List property names along with a specific value indicating if a row is eligible for deletion during the merge operation. This option provides a way to mark rows for deletion based on certain criteria. Only applies if MergeMode is set to Delta.

Declaration

{{< /rawhtml >}} ```C# public ICollection DeleteColumns { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<DeleteColumn>

EvictionPolicy

The eviction policy for the cache.

Declaration

{{< /rawhtml >}} ```C# public CacheEvictionPolicy EvictionPolicy { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
CacheEvictionPolicy

FindDuplicates

Indicates whether to look for duplicate records

Declaration

{{< /rawhtml >}} ```C# public bool FindDuplicates { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

MaxCacheSize

The maximum number of records to cache in memory.

Declaration

{{< /rawhtml >}} ```C# public int MaxCacheSize { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

MergeMode

Specifies the merge mode. Default is Full.

Declaration

{{< /rawhtml >}} ```C# public MergeMode MergeMode { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
MergeMode

ReadConnection

Only applies if CacheMode is set to Partial. Another connection is needed to read from the destination table while the merge operation is running.

Declaration

{{< /rawhtml >}} ```C# public IDbConnection ReadConnection { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
IDbConnection

UpdateColumns

Specify properties to be updated when a row needs updating, by default all non-ID columns are updated.

Declaration

{{< /rawhtml >}} ```C# public ICollection UpdateColumns { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ICollection<UpdateColumn>