Enum AlternativeBulkCopy

Defines type of multi-row INSERT operation to generate for RowByRow bulk copy mode.

Namespace: LinqToDB.DataProvider.Oracle
Assembly: linq2db.dll
Syntax
public enum AlternativeBulkCopy : int

Fields

Name Description
InsertAll

This mode generates INSERT ALL statement. Note that INSERT ALL doesn't support sequences and will use single generated value for all rows.

INSERT ALL
    INTO target_table VALUES(/*row data*/)
    ...
    INTO target_table VALUES(/*row data*/)
InsertDual

This mode generates INSERT ... SELECT statement.

INSERT INTO target_table(/*columns*/)
    SELECT /*row data*/ FROM DUAL
    UNION ALL
    ...
    UNION ALL
    SELECT /*row data*/ FROM DUAL
InsertInto

This mode performs regular INSERT INTO query with array of values for each column.

INSERT INTO target_table(/*columns*/)
    VALUES(:column1ArrayParameter, ..., :columnXArrayParameter)

Extension Methods