Interface IConnectionManager

Inherited Members

System.IDisposable.Dispose()

Namespace: ETLBox.Connection

Assembly: ETLBox.dll

Syntax

public interface IConnectionManager : IDisposable

Properties

ConnectionManagerType

Declaration

ConnectionManagerType ConnectionManagerType { get; }

Property Value

Type	Description
ConnectionManagerType

ConnectionString

Declaration

IDbConnectionString ConnectionString { get; set; }

Property Value

Type	Description
IDbConnectionString

IsInBulkInsert

Declaration

bool IsInBulkInsert { get; set; }

Property Value

Type	Description
System.Boolean

IsOdbcOrOleDbConnection

Declaration

bool IsOdbcOrOleDbConnection { get; }

Property Value

Type	Description
System.Boolean

LeaveOpen

Declaration

bool LeaveOpen { get; set; }

Property Value

Type	Description
System.Boolean

MaxLoginAttempts

Declaration

int MaxLoginAttempts { get; set; }

Property Value

Type	Description
System.Int32

PP

Declaration

string PP { get; }

Property Value

Type	Description
System.String

QB

Declaration

string QB { get; }

Property Value

Type	Description
System.String

QE

Declaration

string QE { get; }

Property Value

Type	Description
System.String

State

Declaration

ConnectionState? State { get; }

Property Value

Type	Description
System.Nullable<System.Data.ConnectionState>

SupportComputedColumns

Declaration

bool SupportComputedColumns { get; }

Property Value

Type	Description
System.Boolean

SupportDatabases

Declaration

bool SupportDatabases { get; }

Property Value

Type	Description
System.Boolean

SupportProcedures

Declaration

bool SupportProcedures { get; }

Property Value

Type	Description
System.Boolean

SupportSchemas

Declaration

bool SupportSchemas { get; }

Property Value

Type	Description
System.Boolean

Transaction

Declaration

IDbTransaction Transaction { get; set; }

Property Value

Type	Description
System.Data.IDbTransaction

Methods

AfterBulkInsert(String)

Declaration

void AfterBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName

BeforeBulkInsert(String)

Declaration

void BeforeBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName

BeginTransaction()

Declaration

void BeginTransaction()

BeginTransaction(IsolationLevel)

Declaration

void BeginTransaction(IsolationLevel isolationLevel)

Parameters

Type	Name	Description
System.Data.IsolationLevel	isolationLevel

BulkInsert(ITableData, String)

Declaration

void BulkInsert(ITableData data, string tableName)

Parameters

Type	Name	Description
ITableData	data
System.String	tableName

CheckIfTableOrViewExists(String)

Declaration

bool CheckIfTableOrViewExists(string objectName)

Parameters

Type	Name	Description
System.String	objectName

Returns

Type	Description
System.Boolean

CheckLicenseOrThrow(Int32)

Declaration

void CheckLicenseOrThrow(int count)

Parameters

Type	Name	Description
System.Int32	count

CleanUpBulkInsert(String)

Declaration

void CleanUpBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Clone()

Declaration

IConnectionManager Clone()

Returns

Type	Description
IConnectionManager

CloneIfAllowed()

Declaration

IConnectionManager CloneIfAllowed()

Returns

Type	Description
IConnectionManager

Close()

Declaration

void Close()

CloseIfAllowed()

Declaration

void CloseIfAllowed()

CloseTransaction()

Declaration

void CloseTransaction()

CommitTransaction()

Declaration

void CommitTransaction()

CreateCommand(String, IEnumerable<QueryParameter>)

Declaration

IDbCommand CreateCommand(string commandText, IEnumerable<QueryParameter> parameterList)

Parameters

Type	Name	Description
System.String	commandText
System.Collections.Generic.IEnumerable<QueryParameter>	parameterList

Returns

Type	Description
System.Data.IDbCommand

ExecuteNonQuery(String, IEnumerable<QueryParameter>)

Declaration

int ExecuteNonQuery(string command, IEnumerable<QueryParameter> parameterList = null)

Parameters

Type	Name	Description
System.String	command
System.Collections.Generic.IEnumerable<QueryParameter>	parameterList

Returns

Type	Description
System.Int32

ExecuteReader(String, IEnumerable<QueryParameter>)

Declaration

IDataReader ExecuteReader(string command, IEnumerable<QueryParameter> parameterList = null)

Parameters

Type	Name	Description
System.String	command
System.Collections.Generic.IEnumerable<QueryParameter>	parameterList

Returns

Type	Description
System.Data.IDataReader

ExecuteScalar(String, IEnumerable<QueryParameter>)

Declaration

object ExecuteScalar(string command, IEnumerable<QueryParameter> parameterList = null)

Parameters

Type	Name	Description
System.String	command
System.Collections.Generic.IEnumerable<QueryParameter>	parameterList

Returns

Type	Description
System.Object

Open()

Declaration

void Open()

PrepareBulkInsert(String)

Declaration

void PrepareBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName

ReadTableDefinition(ObjectNameDescriptor)

Declaration

TableDefinition ReadTableDefinition(ObjectNameDescriptor TN)

Parameters

Type	Name	Description
ObjectNameDescriptor	TN

Returns

Type	Description
TableDefinition

RollbackTransaction()

Declaration

void RollbackTransaction()