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

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

The database type for the connection manager.

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.

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.

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.

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

Will set the database settings SET PAGE_VERIFY NONE and SET RECOVERY BULK_LOGGED Settings will be reverted after the bulk insert operation.

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

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

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.

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.

Performs a bulk delete

Performs a bulk insert

Performs a bulk select

Performs a bulk update

Called after the whole bulk insert operation to change back settings made to improve bulk insert performance

Cretes a clone of the current connection manager

By default, a db connection is created with the given connection string value. Override this method if you want to pass additional properties to the specific Ado.NET db connection.

Performs preparations needed to improved performance of a bulk insert operation