Class ClickHouseConnectionManager

{{< /rawhtml >}} ```C# public class ClickHouseConnectionManager : DbConnectionManager, IConnectionManager, IConnectionManager, IDisposable ``` {{< rawhtml >}}

Examples

ControlFlow.DefaultDbConnection = new ClickHouseConnectionManager("Host=localhost;Port=8123;Username=default;Database=default;");

Constructors

ClickHouseConnectionManager()

Declaration

{{< /rawhtml >}} ```C# public ClickHouseConnectionManager() ``` {{< rawhtml >}}

ClickHouseConnectionManager(ClickHouseConnectionString)

Declaration

{{< /rawhtml >}} ```C# public ClickHouseConnectionManager(ClickHouseConnectionString connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
ClickHouseConnectionString	connectionString

ClickHouseConnectionManager(string)

Declaration

{{< /rawhtml >}} ```C# public ClickHouseConnectionManager(string connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	connectionString

Properties

ConnectionType

The database type for the connection manager.

Declaration

{{< /rawhtml >}} ```C# public override ConnectionType ConnectionType { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
ConnectionType

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.ConnectionType

MaxParameterSizeBulkCopy

Returns the maximum amount of parameters that can be used for bulk inserts.

Declaration

{{< /rawhtml >}} ```C# public override int MaxParameterSizeBulkCopy { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.MaxParameterSizeBulkCopy

MaxParameterSizeSql

Returns the maximum amount of parameters that can be passed into a sql query.

Declaration

{{< /rawhtml >}} ```C# public override int MaxParameterSizeSql { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.MaxParameterSizeSql

QB

The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'

Declaration

{{< /rawhtml >}} ```C# public override string QB { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.QB

QE

The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'

Declaration

{{< /rawhtml >}} ```C# public override string QE { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.QE

SupportIndexes

Indicates if database server does support indexes.

Declaration

{{< /rawhtml >}} ```C# public override bool SupportIndexes { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.SupportIndexes

SupportProcedures

Indicates if the database supports procedures

Declaration

{{< /rawhtml >}} ```C# public override bool SupportProcedures { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.SupportProcedures

SupportSchemas

Indicates if the database supports schemas In MySql, this is false because the schema here is a database in ETLBox. Use SupportDatabases instead

Declaration

{{< /rawhtml >}} ```C# public override bool SupportSchemas { get; protected set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.SupportSchemas

Methods

BulkDelete(ITableData)

Performs a bulk delete

Declaration

{{< /rawhtml >}} ```C# public override void BulkDelete(ITableData data) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
ITableData	data	Batch of data

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.BulkDelete(ETLBox.ITableData)

BulkInsert(ITableData)

Performs a bulk insert

Declaration

{{< /rawhtml >}} ```C# public override void BulkInsert(ITableData data) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
ITableData	data	Batch of data

Overrides

ETLBox.DbConnectionManager<ClickHouse.Driver.ADO.ClickHouseConnection, System.Data.Common.DbTransaction, ClickHouse.Driver.ADO.Parameters.ClickHouseDbParameter>.BulkInsert(ETLBox.ITableData)

BulkSelect(ITableData, ICollection<string>, Action, Action, params Action<object>[])

Performs a bulk select

Declaration

{{< /rawhtml >}} ```C# public override void BulkSelect(ITableData data, ICollection selectColumnNames, Action beforeRowReadAction, Action afterRowReadAction, params Action

Type	Name	Description
ITableData	data	Batch of data needed for the where condition
ICollection<string>	selectColumnNames	Column names included in the select
Action	beforeRowReadAction	Action invoked before any data is read
Action	afterRowReadAction	Action invoked after all data is read
Action<object>[]	rowActions