Class BaseSqlReader

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

public abstract class BaseSqlReader : ISourceReader, IDisposable, IResponseWriter

Inheritance

object

BaseSqlReader

Implements

ISourceReader

IDisposable

IResponseWriter

Derived

DynamicwebSourceReader

SqlSourceReader

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

BaseSqlReader()

protected BaseSqlReader()

BaseSqlReader(Mapping, SqlConnection)

public BaseSqlReader(Mapping mapping, SqlConnection connection)

Parameters

mapping Mapping

connection SqlConnection

Fields

_command

protected SqlCommand? _command

Field Value

SqlCommand

_reader

protected SqlDataReader? _reader

Field Value

SqlDataReader

mapping

protected Mapping mapping

Field Value

Mapping

Properties

PkColumnsForResponseMapping

protected IEnumerable<string> PkColumnsForResponseMapping { get; }

Property Value

IEnumerable<string>

Methods

Close()

Closes this instance.

public void Close()

Dispose()

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

public void Dispose()

GetColumns()

protected virtual string GetColumns()

Returns

string

GetColumnsFromMappingConditions()

protected string GetColumnsFromMappingConditions()

Returns

string

GetColumnsFromMappingConditions(string[])

protected string GetColumnsFromMappingConditions(string[] columnsToSkip)

Parameters

columnsToSkip string[]

Returns

string

GetDistinctColumnsFromMapping()

protected string GetDistinctColumnsFromMapping()

Returns

string

GetDistinctColumnsFromMapping(string[])

protected string GetDistinctColumnsFromMapping(string[] columnsToSkip)

Parameters

columnsToSkip string[]

Returns

string

GetFromTables()

protected virtual string GetFromTables()

Returns

string

GetNext()

base implementation,

public virtual Dictionary<string, object> GetNext()

Returns

Dictionary<string, object>

GetPrimaryKeyColumns(bool)

protected IEnumerable<string> GetPrimaryKeyColumns(bool returnOnlyMissedInMappings = true)

Parameters

returnOnlyMissedInMappings bool

Returns

IEnumerable<string>

IsDone()

Determines whether this instance is done reading from the source.

public virtual bool IsDone()

Returns

bool

true if this instance is done; otherwise, false.

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.