Class SQLiteConnectionManager

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

Examples

ControlFlow.DefaultDbConnection =
  new.SQLiteConnectionManager(new SQLiteConnectionString(
    "Data Source=.\db\SQLite.db;Version=3;"));

Constructors

SQLiteConnectionManager()

Declaration

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

SQLiteConnectionManager(SQLiteConnectionString)

Declaration

{{< /rawhtml >}} ```C# public SQLiteConnectionManager(SQLiteConnectionString connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
SQLiteConnectionString	connectionString

SQLiteConnectionManager(string)

Declaration

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

Parameters

Type	Name	Description
string	connectionString

Properties

BulkInserts

Instead of using single values inserts (with a INSERT INTO .. VALUES () statement), data is inserted in batches using a INSERT INTO .. VALUES (), (), () syntax. All other connectors already use the batch variant, but SQLite is optimized for single inserts and sometimes has issues with a bigger amount of parameters passed into a sql statement. Using bulk inserts is not compatible with older version (SQLite < 3.15.0)

Declaration

{{< /rawhtml >}} ```C# public bool BulkInserts { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.ConnectionType

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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.MaxParameterSizeSql

ModifyDBSettings

Will set the PRAGMA synchronous = OFF and PRAGMA journal_mode = MEMORY settings before the bulk insert. The changes will be reverted after the bulk insert operation.

Declaration

{{< /rawhtml >}} ```C# public bool ModifyDBSettings { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
bool

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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.QE

SupportDatabases

Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.

Declaration

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

Property Value

Type	Description
bool

Overrides

ETLBox.DbConnectionManager<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.SupportDatabases

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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.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<System.Data.SQLite.SQLiteConnection, System.Data.SQLite.SQLiteTransaction, System.Data.SQLite.SQLiteParameter>.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