Class ColumnMapping

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

Mapping shows which column from the source goes to which column in the destination.

public class ColumnMapping

Inheritance

object

ColumnMapping

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

ColumnMapping()

protected ColumnMapping()

ColumnMapping(Column?, Column?, int, bool)

Initializes a new instance of the ColumnMapping class.

public ColumnMapping(Column? sourceColumn, Column? destinationColumn, int id, bool iskey = false)

Parameters

sourceColumn Column

The source column.

destinationColumn Column

The destination column.

id int

The id.

iskey bool

if set to true [iskey].

ColumnMapping(Column?, Column?, int, bool, bool)

public ColumnMapping(Column? sourceColumn, Column? destinationColumn, int id, bool iskey, bool useCodeExtension)

Parameters

sourceColumn Column

destinationColumn Column

id int

iskey bool

useCodeExtension bool

ColumnMapping(XmlNode, ISource?, IDestination?, Table?, Table?, int)

Initializes a new instance of the ColumnMapping class from an XML node. This constructor parses the output created by the method saveAsXML()

public ColumnMapping(XmlNode xmlNode, ISource? source, IDestination? destination, Table? sourceTable, Table? destinationTable, int id)

Parameters

xmlNode XmlNode

The XML node.

source ISource

The source.

destination IDestination

The destination.

sourceTable Table

The source table.

destinationTable Table

The destination table.

id int

The id.

Fields

ScriptValueForInsert

defines whether to use Script value only on insert new rows and skip on update

public bool ScriptValueForInsert

Field Value

bool

Properties

Active

Gets or sets a value indicating whether this ColumnMapping is active.

public virtual bool Active { get; set; }

Property Value

bool

true if active; otherwise, false.

Comment

public string? Comment { get; set; }

Property Value

string

DestinationColumn

Gets or sets the destination column.

public virtual Column? DestinationColumn { get; set; }

Property Value

Column

The destination column.

FormatCulture

public string? FormatCulture { get; set; }

Property Value

string

IsKey

Gets or sets a value indicating whether this column mapping is a primary key.

public virtual bool IsKey { get; set; }

Property Value

bool

true if this column mapping is key; otherwise, false.

Mapping

public Mapping? Mapping { get; }

Property Value

Mapping

NullEmptyActionType

Null or empty source column value handling type

public NullEmptyActionType NullEmptyActionType { get; set; }

Property Value

NullEmptyActionType

NullEmptyActionValue

The value to use instead of the null or empty source column value

public string? NullEmptyActionValue { get; set; }

Property Value

string

OriginalDestinationColumnName

The is used to store the original destination column name fetched from the job file when the destination table does not exists

public string? OriginalDestinationColumnName { get; set; }

Property Value

string

OriginalSourceColumnName

The is used to store the original source column name fetched from the job file when the source table does not exists

public string? OriginalSourceColumnName { get; set; }

Property Value

string

ScriptTypeProvider

public ScriptTypeProvider? ScriptTypeProvider { get; set; }

Property Value

ScriptTypeProvider

Sort

public int Sort { get; set; }

Property Value

int

SourceColumn

Gets or sets the source column.

public virtual Column? SourceColumn { get; set; }

Property Value

Column

The source column.

Methods

ConvertInputValueToOutputValue(object)

public object? ConvertInputValueToOutputValue(object inputObject)

Parameters

inputObject object

Returns

object

GetCulture()

public CultureInfo GetCulture()

Returns

CultureInfo

GetId()

Gets the id of the mapping.

public int GetId()

Returns

int

GetInputToDestinationTypeOutputFormat(object, Column?, Column?, CultureInfo?)

public static object GetInputToDestinationTypeOutputFormat(object inputObject, Column? sourceColumn, Column? destinationColumn, CultureInfo? culture)

Parameters

inputObject object

sourceColumn Column

destinationColumn Column

culture CultureInfo

Returns

object

GetScriptValue()

public string? GetScriptValue()

Returns

string

SetScriptType(ScriptTypeProvider?)

public void SetScriptType(ScriptTypeProvider? scriptType)

Parameters

scriptType ScriptTypeProvider