Class MergeProperties

A list of properties that describe on which the DbMerge can perform which merge operation.

Inheritance
System.Object
MergeProperties
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow
Assembly: ETLBox.dll
Syntax
    public class MergeProperties

Properties

CompareColumns

Property names that should be use to compare if the values of a column are equal, so that the DbMerge can decide if the column needs to be updated.

Declaration
    public ICollection<CompareColumn> CompareColumns { get; set; }
Property Value
TypeDescription
System.Collections.Generic.ICollection<CompareColumn>

DeletionProperties

List of property names and a to-be value that tells the DbMerge if this row can be deleted.

Declaration
    public ICollection<DeleteColumn> DeletionProperties { get; set; }
Property Value
TypeDescription
System.Collections.Generic.ICollection<DeleteColumn>

IdColumns

Property names that are used to check if the columns match (id values are equal).

Declaration
    public ICollection<IdColumn> IdColumns { get; set; }
Property Value
TypeDescription
System.Collections.Generic.ICollection<IdColumn>

UpdateColumns

Property names that describe which columns are actually updated (if an update of the row is necessary). Can be left empty, then all non id columns will be updated.

Declaration
    public ICollection<UpdateColumn> UpdateColumns { get; set; }
Property Value
TypeDescription
System.Collections.Generic.ICollection<UpdateColumn>