Interface IDataTypeConverter

Describe methods that allows to intercept the CREATE TABLE sql generation in a CreateTableTask. It will convert the data type that is defined in a TableColumn into a custom database specific type.

Namespace: ETLBox.Helper
Assembly: ETLBox.dll
Syntax
    public interface IDataTypeConverter

Methods

TryConvertDbDataType(String, ConnectionManagerType)

Tries to convert the data type from the TableColumn into a database specific type.

Declaration
    string TryConvertDbDataType(string dataTypeName, ConnectionManagerType connectionType)
Parameters
TypeNameDescription
System.StringdataTypeName

The specific type name from a table column

ConnectionManagerTypeconnectionType

The database connection type

Returns
TypeDescription
System.String

The type used in the CREATE TABLE statement