Class SqlConnectionManager

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

Examples

ControlFlow.DefaultDbConnection = new SqlConnectionManager(new ConnectionString("Data Source=.;"));

Constructors

SqlConnectionManager()

Declaration

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

SqlConnectionManager(SqlConnectionString)

Declaration

{{< /rawhtml >}} ```C# public SqlConnectionManager(SqlConnectionString connectionString) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
SqlConnectionString	connectionString

SqlConnectionManager(string)

Declaration

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

Parameters

Type	Name	Description
string	connectionString

Properties

AccessToken

If you provide an access token here, this token will be used for authentication with Sql Server

Declaration

{{< /rawhtml >}} ```C# public string AccessToken { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.ConnectionType

DisableCheckConstraints

If set to true, foreign key constraints will not be checked when doing the bulk insert. By default, foreign key constraints are checked. To improve bulk insert performance, you can disable foreign key constrain checks.
This only applies for bulk inserts, and only if ValueGeneratedColumns are empty.

Declaration

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

Property Value

Type	Description
bool

DisableTriggers

If set to true, triggers will not be fired when doing the bulk insert. By default, all triggers are fired in bulk insert operations. This only applies for bulk inserts, and only if ValueGeneratedColumns are empty.

Declaration

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

Property Value

Type	Description
bool

KeepNulls

If inserted data into columns with a DEFAULT constraint, the default value is always used if the mapped property in your data object holds a null value. If you want to insert a NULL value instead (and not trigger the default value generation), set this property to true.

Declaration

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

Property Value

Type	Description
bool

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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.MaxParameterSizeSql

ModifyDBSettings

Will set the database settings SET PAGE_VERIFY NONE and SET RECOVERY BULK_LOGGED Settings 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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.QE

UseRowLocks

By default, a table lock (for all bulk operations) is aquired when data is inserted. (This table lock will also allow concurrent bulk inserts. Only non bulk write operations are not allowed) If you want to use normal inserts/updates while inserted data in bulk, set this value to true to use row locks instead. This only applies for bulk inserts, and only if ValueGeneratedColumns are empty.

Declaration

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

Property Value

Type	Description
bool

UseSqlBulkOperations

By default bulk operations are done creating a temporary table first, and then inserting/updating/deleting data either using a MERGE or DELETE FROM statement. Though this provides better performance, for compatibility purposes you can set this property to true. All bulk operations are then executed as "SQL only" statements. Reading ValueGeneratedColumns is not supported then.

Declaration

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

Property Value

Type	Description
bool

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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.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<Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient.SqlTransaction, Microsoft.Data.SqlClient.SqlParameter>.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