Class BaseSqlProvider

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

[ResponseMapping(true)]
public abstract class BaseSqlProvider : BaseProvider, ISource, IDestination, IParameterizedDestination

Inheritance

object

ConfigurableAddIn

BaseProvider

BaseSqlProvider

Implements

ISource

IDestination

IParameterizedDestination

Derived

DynamicwebProvider

EcomProvider

OrderProvider

SqlProvider

UserProvider

Inherited Members

BaseProvider.TableRelations

BaseProvider.Logger

BaseProvider.JobIsGoingToRun

BaseProvider.GetSchema()

BaseProvider.GetOriginalSourceSchema()

BaseProvider.GetOriginalDestinationSchema()

BaseProvider.OverwriteSourceSchemaToOriginal()

BaseProvider.OverwriteDestinationSchemaToOriginal()

BaseProvider.GetReader(Mapping)

BaseProvider.Close()

BaseProvider.Serialize()

BaseProvider.WorkingDirectory

BaseProvider.FilesFolderName

BaseProvider.ValidateDestinationSettings()

BaseProvider.SchemaIsEditable

BaseProvider.ValidateSourceSettings()

BaseProvider.SaveAsXml(XmlTextWriter)

BaseProvider.UpdateSourceSettings(ISource)

BaseProvider.GetId()

BaseProvider.GetDetails(string)

BaseProvider.Initialize()

BaseProvider.LoadSettings(Job)

BaseProvider.IsSortable(Job, bool)

BaseProvider.OrderTablesByRelations(Job, bool)

BaseProvider.CreateParameterNode(Type, string, string)

BaseProvider.RunJob(Job)

BaseProvider.UpdateDestinationSettings(IDestination)

BaseProvider.CheckCondition(MappingConditional, Dictionary<string, object>)

BaseProvider.ABasePovider

BaseProvider.GetFailedSourceRowMessage(Dictionary<string, object>)

BaseProvider.ProcessInputRow(Dictionary<string, object>, Mapping)

BaseProvider.GetDefaultValue(Type)

BaseProvider.Parameters

BaseProvider.ReplaceMappingConditionalsWithValuesFromRequest(Job)

BaseProvider.UpdateIndexes(IList<string>, ILogger)

ConfigurableAddIn.UpdateFromPost(NameValueCollection)

ConfigurableAddIn.GetIdSuitableString(string)

ConfigurableAddIn.LoadParametersFromXml(string)

ConfigurableAddIn.GetParametersToXml()

ConfigurableAddIn.GetParametersToXml(bool)

ConfigurableAddIn.SetValue(string, object)

ConfigurableAddIn.GetInstanceFromParameterXml<T>(string)

ConfigurableAddIn.RenderAdditionalContent(TextWriter)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

ProviderExtensions.GetTableOptions(IDestination)

ProviderExtensions.IsDestinationFileProvider(IDestination)

ProviderExtensions.IsTableOptionsFeatureSupported(IDestination)

ProviderExtensions.IsSourceFileProvider(ISource)

Properties

TotalRowsAffected

public virtual long TotalRowsAffected { get; set; }

Property Value

long

Methods

GetConnectionString(string?)

protected static string GetConnectionString(string? connectionString)

Parameters

connectionString string

Returns

string

GetSqlSourceSchema(SqlConnection, IEnumerable<string>?)

public static Schema GetSqlSourceSchema(SqlConnection connection, IEnumerable<string>? tableNames = null)

Parameters

connection SqlConnection

tableNames IEnumerable<string>

Returns

Schema

GetTableName(Mapping, bool)

protected static string? GetTableName(Mapping map, bool isSource)

Parameters

map Mapping

isSource bool

Returns

string

GetTableSchema(Mapping, bool)

protected static string? GetTableSchema(Mapping map, bool isSource)

Parameters

map Mapping

isSource bool

Returns

string

LogRunJobError(Exception, Dictionary<string, object>?)

protected void LogRunJobError(Exception ex, Dictionary<string, object>? sourceRow)

Parameters

ex Exception

sourceRow Dictionary<string, object>

OrderItemsByJobMappings<T>(IList<T>, Job, Func<T, string?>, bool)

protected static void OrderItemsByJobMappings<T>(IList<T> entries, Job job, Func<T, string?> tableNameSelector, bool isSource = false)

Parameters

entries IList<T>

job Job

tableNameSelector Func<T, string>

isSource bool

Type Parameters

T

OrderTablesByConstraints(Job, SqlConnection, bool)

protected static void OrderTablesByConstraints(Job job, SqlConnection connection, bool isSource = false)

Parameters

job Job

connection SqlConnection

isSource bool

OrderTablesByConstraints(Job, SqlConnection, bool, Func<string, string?, Table?>?)

protected static void OrderTablesByConstraints(Job job, SqlConnection connection, bool isSource, Func<string, string?, Table?>? getTable)

Parameters

job Job

connection SqlConnection

isSource bool

getTable Func<string, string, Table>

OrderTablesInJob(Job, bool)

public virtual void OrderTablesInJob(Job job, bool isSource)

Parameters

job Job

isSource bool

TryOrderMappingsBySchemaDependencies(Job, bool, Func<string, string?, Table?>?)

protected static bool TryOrderMappingsBySchemaDependencies(Job job, bool isSource, Func<string, string?, Table?>? getTable)

Parameters

job Job

isSource bool

getTable Func<string, string, Table>

Returns

bool

TryOrderTablesInJobUsingSchemaMetadata(Job, bool)

Attempts to order mapped tables by using provider-specific persisted schema metadata instead of querying the database.

public virtual bool TryOrderTablesInJobUsingSchemaMetadata(Job job, bool isSource)

Parameters

job Job

The job whose mappings should be ordered.

isSource bool

true to order source tables; otherwise destination tables.

Returns

bool

true when the provider could order the mappings from persisted metadata alone; otherwise false so the caller can fall back to database-based ordering.

Remarks

The base implementation intentionally returns false. Providers that persist foreign-key metadata, such as SQL-backed providers, override this method to enable in-memory ordering without an extra database lookup during job execution.