Class SqlConnectionManager

Connection manager of a classic ADO.NET connection to a (Microsoft) Sql Server.

Inheritance
System.Object
DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>
SqlConnectionManager
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.Connection
Assembly: ETLBox.SqlServer.dll
Syntax
public class SqlConnectionManager : DbConnectionManager<SqlConnection>, IConnectionManager, IDisposable
Examples
ControlFlow.DefaultDbConnection = new SqlConnectionManager(new ConnectionString("Data Source=.;"));

Constructors

SqlConnectionManager()

Declaration
public SqlConnectionManager()

SqlConnectionManager(SqlConnectionString)

Declaration
public SqlConnectionManager(SqlConnectionString connectionString)
Parameters
Type Name Description
SqlConnectionString connectionString

SqlConnectionManager(String)

Declaration
public SqlConnectionManager(string connectionString)
Parameters
Type Name Description
System.String connectionString

Properties

ConnectionManagerType

The database type for the connection manager.

Declaration
public override ConnectionManagerType ConnectionManagerType { get; }
Property Value
Type Description
ConnectionManagerType
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.ConnectionManagerType

FireTriggers

If set to true, triggers will be fired when doing the bulk insert. By default, no triggers are fired in bulk insert operations.

Declaration
public bool FireTriggers { get; set; }
Property Value
Type Description
System.Boolean

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
public bool ModifyDBSettings { get; set; }
Property Value
Type Description
System.Boolean

QB

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

Declaration
public override string QB { get; }
Property Value
Type Description
System.String
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.QB

QE

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

Declaration
public override string QE { get; }
Property Value
Type Description
System.String
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.QE

Methods

AfterBulkInsert(String)

Called after every bulk insert of a batch

Declaration
public override void AfterBulkInsert(string tableName)
Parameters
Type Name Description
System.String tableName

Destination table name
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.AfterBulkInsert(System.String)

BeforeBulkInsert(String)

Called before every bulk insert of a batch

Declaration
public override void BeforeBulkInsert(string tableName)
Parameters
Type Name Description
System.String tableName

Destination table name
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.BeforeBulkInsert(System.String)

BulkInsert(ITableData, String)

Performs a bulk insert

Declaration
public override void BulkInsert(ITableData data, string tableName)
Parameters
Type Name Description
ITableData data

Batch of data
System.String tableName

Destination table name
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.BulkInsert(ETLBox.ControlFlow.ITableData, System.String)

CheckLicenseOrThrow(Int32)

Checks for the current license after 10.000 rows. If no license found, this will throw an exception.

Declaration
public override void CheckLicenseOrThrow(int progressCount)
Parameters
Type Name Description
System.Int32 progressCount
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.CheckLicenseOrThrow(System.Int32)

CleanUpBulkInsert(String)

Called after the whole bulk insert operation (all batches)

Declaration
public override void CleanUpBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.CleanUpBulkInsert(System.String)

Clone()

Cretes a clone of the current connection manager

Declaration
public override IConnectionManager Clone()
Returns
Type Description
IConnectionManager

A instance copy of the current connection manager
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.Clone()

PrepareBulkInsert(String)

Called before the whole bulk insert operation (all batches)

Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
Type Name Description
System.String tablename
Overrides
ETLBox.Connection.DbConnectionManager<Microsoft.Data.SqlClient.SqlConnection>.PrepareBulkInsert(System.String)

Implements

System.IDisposable