Class MergeProperties
A list of properties that describe on which the DbMerge can perform which merge operation.
Inheritance
object
MergeProperties
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
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
| Type | Description |
|---|---|
| System.Collections.Generic.ICollection<T><CompareColumn> |
DeleteColumns
List of property names and a to-be value that tells the DbMerge if this row can be deleted.
Declaration
public ICollection<DeleteColumn> DeleteColumns { get; set; }
Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.ICollection<T><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
| Type | Description |
|---|---|
| System.Collections.Generic.ICollection<T><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
| Type | Description |
|---|---|
| System.Collections.Generic.ICollection<T><UpdateColumn> |