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

GetSqlSourceSchema(SqlConnection, IEnumerable<string>?)

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

Parameters

connection SqlConnection

tableNames IEnumerable<string>

Returns

Schema

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

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

Parameters

ex Exception

sourceRow Dictionary<string, object>

OrderTablesByConstraints(Job, SqlConnection, bool)

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

Parameters

job Job

connection SqlConnection

isSource bool

OrderTablesInJob(Job, bool)

public virtual void OrderTablesInJob(Job job, bool isSource)

Parameters

job Job

isSource bool