Class MappingExtensions

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

public static class MappingExtensions

Inheritance

object

MappingExtensions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

GetAutoIdColumnName(string)

Gets the PK Id column

public static string GetAutoIdColumnName(string databaseTableName)

Parameters

databaseTableName string

The table name

Returns

string

The Id column name

GetConditionalSql(string, string, MappingConditional?, int, ConditionalGroupOperator)

public static string GetConditionalSql(string conditionalsSql, string columnName, MappingConditional? mappingConditional, int conditionalCount, ConditionalGroupOperator groupOperator)

Parameters

conditionalsSql string

columnName string

mappingConditional MappingConditional

conditionalCount int

groupOperator ConditionalGroupOperator

Returns

string

GetConditionalsSql(out List<SqlParameter>, MappingConditionalCollection, bool, bool)

public static string GetConditionalsSql(out List<SqlParameter> parameters, MappingConditionalCollection conditionals, bool skipVirtualColumns, bool useDestinationColumns)

Parameters

parameters List<SqlParameter>

conditionals MappingConditionalCollection

skipVirtualColumns bool

useDestinationColumns bool

Returns

string

GetKeyColumnMappings(IEnumerable<ColumnMapping>)

public static IEnumerable<ColumnMapping> GetKeyColumnMappings(this IEnumerable<ColumnMapping> mappings)

Parameters

mappings IEnumerable<ColumnMapping>

Returns

IEnumerable<ColumnMapping>

GetLanguageIdColumnName(string)

Gets the LanguageId column

public static string GetLanguageIdColumnName(string databaseTableName)

Parameters

databaseTableName string

The table name

Returns

string

The LanguageId column name

GetShopIdColumnName(string)

Gets the ShopId column

public static string GetShopIdColumnName(string databaseTableName)

Parameters

databaseTableName string

The table name

Returns

string

The ShopId column name

GetSourceColumnsFromCodeScript(ColumnMapping)

public static IEnumerable<string> GetSourceColumnsFromCodeScript(this ColumnMapping columnMapping)

Parameters

columnMapping ColumnMapping

Returns

IEnumerable<string>

HasCodeScriptWithData(ColumnMapping)

public static bool HasCodeScriptWithData(this ColumnMapping columnMapping)

Parameters

columnMapping ColumnMapping

Returns

bool

HasScriptWithValue(ColumnMapping)

public static bool HasScriptWithValue(this ColumnMapping columnMapping)

Parameters

columnMapping ColumnMapping

Returns

bool

IsKeyChangeAllowed(ColumnMapping)

public static bool IsKeyChangeAllowed(this ColumnMapping columnMapping)

Parameters

columnMapping ColumnMapping

Returns

bool

IsKeyColumn(Column, IEnumerable<ColumnMapping>)

public static bool IsKeyColumn(this Column column, IEnumerable<ColumnMapping> mappings)

Parameters

column Column

mappings IEnumerable<ColumnMapping>

Returns

bool

IsKeyColumnExists(IEnumerable<ColumnMapping>)

public static bool IsKeyColumnExists(this IEnumerable<ColumnMapping> mappings)

Parameters

mappings IEnumerable<ColumnMapping>

Returns

bool

ReplaceKeyColumnsWithAutoIdIfExists(Mapping)

public static IEnumerable<ColumnMapping> ReplaceKeyColumnsWithAutoIdIfExists(Mapping mapping)

Parameters

mapping Mapping

Returns

IEnumerable<ColumnMapping>

TryToggleIsKey(IEnumerable<ColumnMapping>, ColumnMapping)

public static bool TryToggleIsKey(this IEnumerable<ColumnMapping> columnsMappings, ColumnMapping columnMapping)

Parameters

columnsMappings IEnumerable<ColumnMapping>

columnMapping ColumnMapping

Returns

bool