Class DynamicwebBulkInsertDestinationWriter

Namespace

Dynamicweb.DataIntegration.Providers.DynamicwebProvider

Assembly

Dynamicweb.DataIntegration.dll

Dynamicweb Bulk Insert destiation writer

public class DynamicwebBulkInsertDestinationWriter : BaseSqlWriter, IDestinationWriter, IDisposable

Inheritance

object

BaseDestinationWriter

BaseSqlWriter

DynamicwebBulkInsertDestinationWriter

Implements

IDestinationWriter

IDisposable

Inherited Members

BaseSqlWriter.RowsAffected

BaseSqlWriter.GetExtraConditions(Mapping, string, string)

BaseSqlWriter.DeactivateMissingProductsInMainTable(Mapping, SqlCommand, string, string, bool)

BaseSqlWriter.DeleteRowsFromMainTable(bool, Mapping, string, SqlCommand, string)

BaseSqlWriter.DeleteRowsFromMainTable(bool, Dictionary<string, Mapping>, string, SqlCommand)

BaseSqlWriter.DeleteExcessFromMainTable(Mapping, string, SqlCommand, string, bool)

BaseSqlWriter.DeleteExcessFromMainTable(SqlCommand, Mapping, string, string, bool)

BaseSqlWriter.DeleteExcessFromMainTable(SqlCommand, Dictionary<string, Mapping>, string)

BaseSqlWriter.DeleteExistingFromMainTable(Mapping, string, SqlCommand, string)

BaseSqlWriter.DeleteExistingFromMainTable(SqlCommand, Mapping, string, string)

BaseSqlWriter.SqlBulkCopierWriteToServer(SqlBulkCopy, DataTable, bool, Mapping, ILogger)

BaseSqlWriter.MoveDataToMainTable(Mapping, SqlCommand, SqlTransaction, string)

BaseSqlWriter.MoveDataToMainTable(SqlCommand, Mapping, SqlTransaction, string)

BaseSqlWriter.MoveDataToMainTable(Mapping, SqlCommand, SqlTransaction, string, bool)

BaseSqlWriter.MoveDataToMainTable(SqlCommand, Mapping, SqlTransaction, string, bool)

BaseSqlWriter.MoveDataToMainTable(Mapping, SqlCommand, SqlTransaction, string, bool, bool)

BaseSqlWriter.HasIdentity(Mapping)

BaseSqlWriter.HasIdentity(ColumnMappingCollection)

BaseSqlWriter.GetMoveDataToMainTableException(Exception, SqlCommand, Mapping, string, List<string>)

BaseSqlWriter.GetMoveDataToMainTableException(Exception, SqlCommand, Mapping, string, List<string>, string, string)

BaseDestinationWriter.Initialize()

BaseDestinationWriter.DeleteRowsMissingFromSource()

BaseDestinationWriter.GetRowValueNotFoundMessage(Dictionary<string, object>, string, string)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

DynamicwebBulkInsertDestinationWriter(Mapping, SqlCommand, bool, bool)

Initializes a new instance of the DynamicwebBulkInsertDestinationWriter class.

public DynamicwebBulkInsertDestinationWriter(Mapping mapping, SqlCommand mockSqlCommand, bool shopDeactivateMissingProducts, bool deleteMissing)

Parameters

mapping Mapping

Mapping

mockSqlCommand SqlCommand

Mock SqlCommand

shopDeactivateMissingProducts bool

Deactivate missing products

deleteMissing bool

Delete rows from Dynamicweb not present in the import

DynamicwebBulkInsertDestinationWriter(Mapping, SqlConnection, bool, bool, ILogger?, AssortmentHandler?, bool)

Initializes a new instance of the DynamicwebBulkInsertDestinationWriter class.

public DynamicwebBulkInsertDestinationWriter(Mapping mapping, SqlConnection connection, bool shopDeactivateMissingProducts, bool deleteMissing, ILogger? logger, AssortmentHandler? assortmentHandler, bool discardDuplicates)

Parameters

mapping Mapping

Mapping

connection SqlConnection

Connection

shopDeactivateMissingProducts bool

Deactivate missing products

deleteMissing bool

Delete rows from Dynamicweb not present in the import

logger ILogger

Logger instance

assortmentHandler AssortmentHandler

AssortmentHandler instance

discardDuplicates bool

DynamicwebBulkInsertDestinationWriter(Mapping, SqlConnection, bool, bool, ILogger?, AssortmentHandler?, bool, bool)

Initializes a new instance of the DynamicwebBulkInsertDestinationWriter class.

public DynamicwebBulkInsertDestinationWriter(Mapping mapping, SqlConnection connection, bool shopDeactivateMissingProducts, bool deleteMissing, ILogger? logger, AssortmentHandler? assortmentHandler, bool discardDuplicates, bool removeMissingAfterImportDestinationTablesOnly)

Parameters

mapping Mapping

Mapping

connection SqlConnection

Connection

shopDeactivateMissingProducts bool

Deactivate missing products

deleteMissing bool

Delete rows from Dynamicweb not present in the import

logger ILogger

Logger instance

assortmentHandler AssortmentHandler

AssortmentHandler instance

discardDuplicates bool

removeMissingAfterImportDestinationTablesOnly bool

Remove missing rows after import in the destination tables only

DynamicwebBulkInsertDestinationWriter(Mapping, SqlConnection, bool, bool, ILogger?, AssortmentHandler?, bool, bool, bool)

Initializes a new instance of the DynamicwebBulkInsertDestinationWriter class.

public DynamicwebBulkInsertDestinationWriter(Mapping mapping, SqlConnection connection, bool shopDeactivateMissingProducts, bool deleteMissing, ILogger? logger, AssortmentHandler? assortmentHandler, bool discardDuplicates, bool removeMissingAfterImportDestinationTablesOnly, bool skipFailingRows)

Parameters

mapping Mapping

Mapping

connection SqlConnection

Connection

shopDeactivateMissingProducts bool

Deactivate missing products

deleteMissing bool

Delete rows from Dynamicweb not present in the import

logger ILogger

Logger instance

assortmentHandler AssortmentHandler

Assortment Handler

discardDuplicates bool

Discard Duplicates

removeMissingAfterImportDestinationTablesOnly bool

Remove missing rows after import in the destination tables only

skipFailingRows bool

Skip failing rows

Properties

DataToWrite

protected DataSet DataToWrite { get; set; }

Property Value

DataSet

DuplicateRowsHandler

protected DuplicateRowsHandler? DuplicateRowsHandler { get; set; }

Property Value

DuplicateRowsHandler

Logger

protected ILogger? Logger { get; set; }

Property Value

ILogger

Mapping

Gets the mapping.

public Mapping Mapping { get; }

Property Value

Mapping

SqlBulkCopier

protected SqlBulkCopy SqlBulkCopier { get; set; }

Property Value

SqlBulkCopy

TableToWrite

protected DataTable TableToWrite { get; set; }

Property Value

DataTable

Methods

Close()

Close writer

public void Close()

Dispose()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

public void Dispose()

Dispose(bool)

protected virtual void Dispose(bool disposing)

Parameters

disposing bool

Write(Dictionary<string, object>)

Writes the specified row.

public void Write(Dictionary<string, object> row)

Parameters

row Dictionary<string, object>

The row to be written.