Enum AlternativeBulkCopy

Namespace

LinqToDB.DataProvider.Oracle

Assembly

linq2db.dll

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

public enum AlternativeBulkCopy

Extension Methods

Sql.Between<T>(T, T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T?)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T?)

Sql.NotBetween<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Fields

InsertAll = 0

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 = 2

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 = 1

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

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