EFBoxTitle here
Summary here
MergeBulkOptions<T>
Class MergeBulkOptions<T>
Options used for BulkMerge operations.
Inherited Members
Namespace: EFBox
Assembly: EFBox.dll
Syntax
public class MergeBulkOptions<T> : BulkOptionsShared<T>
Type Parameters
| Name | Description |
|---|---|
| T | Type of data used for operation |
Properties
CacheMode
Determines the cache mode. Default is ETLBox.CacheMode.Full. If set to ETLBox.CacheMode.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 ETLBox.MergeMode.Full, this setting is ignored (ETLBox.CacheMode.Full is used)
Declaration
public CacheMode CacheMode { get; set; }
Property Value
| Type | Description |
|---|---|
| ETLBox.CacheMode |
CompareColumns
Define properties to check for equality during merge to decide if an update is needed.
Declaration
public ICollection<CompareColumn> CompareColumns { get; set; }
Property Value
| Type | Description |
|---|---|
| ICollection<><CompareColumn> |
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 ETLBox.MergeMode.Delta.
Declaration
public ICollection<DeleteColumn> DeleteColumns { get; set; }
Property Value
| Type | Description |
|---|---|
| ICollection<><DeleteColumn> |
FindDuplicates
Indicates whether to look for duplicate records
Declaration
public bool FindDuplicates { get; set; }
Property Value
| Type | Description |
|---|---|
| bool |
MergeMode
Specifies the merge mode. Default is ETLBox.MergeMode.Full.
Declaration
public MergeMode MergeMode { get; set; }
Property Value
| Type | Description |
|---|---|
| ETLBox.MergeMode |
UpdateColumns
Specify properties to be updated when a row needs updating, by default all non-ID columns are updated.
Declaration
public ICollection<UpdateColumn> UpdateColumns { get; set; }
Property Value
| Type | Description |
|---|---|
| ICollection<><UpdateColumn> |