Table of Contents

Class OracleDataProvider

Namespace
LinqToDB.DataProvider.Oracle
Assembly
linq2db.dll
public abstract class OracleDataProvider : DynamicDataProviderBase<OracleProviderAdapter>, IDataProvider
Inheritance
OracleDataProvider
Implements
Inherited Members
Extension Methods

Constructors

OracleDataProvider(string, OracleProvider, OracleVersion)

protected OracleDataProvider(string name, OracleProvider provider, OracleVersion version)

Parameters

name string
provider OracleProvider
version OracleVersion

Properties

Provider

public OracleProvider Provider { get; }

Property Value

OracleProvider

SupportedTableOptions

public override TableOptions SupportedTableOptions { get; }

Property Value

TableOptions

Version

public OracleVersion Version { get; }

Property Value

OracleVersion

Methods

BulkCopyAsync<T>(DataOptions, ITable<T>, IEnumerable<T>, CancellationToken)

public override Task<BulkCopyRowsCopied> BulkCopyAsync<T>(DataOptions options, ITable<T> table, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull

Parameters

options DataOptions
table ITable<T>
source IEnumerable<T>
cancellationToken CancellationToken

Returns

Task<BulkCopyRowsCopied>

Type Parameters

T

BulkCopy<T>(DataOptions, ITable<T>, IEnumerable<T>)

public override BulkCopyRowsCopied BulkCopy<T>(DataOptions options, ITable<T> table, IEnumerable<T> source) where T : notnull

Parameters

options DataOptions
table ITable<T>
source IEnumerable<T>

Returns

BulkCopyRowsCopied

Type Parameters

T

ClearCommandParameters(DbCommand)

public override void ClearCommandParameters(DbCommand command)

Parameters

command DbCommand

ConvertParameterType(Type, DbDataType)

public override Type ConvertParameterType(Type type, DbDataType dataType)

Parameters

type Type
dataType DbDataType

Returns

Type

CreateSqlBuilder(MappingSchema, DataOptions)

public override ISqlBuilder CreateSqlBuilder(MappingSchema mappingSchema, DataOptions dataOptions)

Parameters

mappingSchema MappingSchema
dataOptions DataOptions

Returns

ISqlBuilder

GetQueryParameterNormalizer()

Returns instance of IQueryParametersNormalizer, which implements normalization logic for parameters of single query. E.g. it could include:

  • trimming names that are too long
  • removing/replacing unsupported characters
  • name deduplication for parameters with same name
. For implementation without state it is recommended to return static instance. E.g. this could be done for providers with positional parameters that ignore names.
public override IQueryParametersNormalizer GetQueryParameterNormalizer()

Returns

IQueryParametersNormalizer

GetSchemaProvider()

public override ISchemaProvider GetSchemaProvider()

Returns

ISchemaProvider

GetSqlOptimizer(DataOptions)

public override ISqlOptimizer GetSqlOptimizer(DataOptions dataOptions)

Parameters

dataOptions DataOptions

Returns

ISqlOptimizer

InitCommand(DataConnection, DbCommand, CommandType, string, DataParameter[]?, bool)

Initializes DataConnection command object.

public override DbCommand InitCommand(DataConnection dataConnection, DbCommand command, CommandType commandType, string commandText, DataParameter[]? parameters, bool withParameters)

Parameters

dataConnection DataConnection

Data connection instance to initialize with new command.

command DbCommand

Command instance to initialize.

commandType CommandType

Type of command.

commandText string

Command SQL.

parameters DataParameter[]

Optional list of parameters to add to initialized command.

withParameters bool

Flag to indicate that command has parameters. Used to configure parameters support when method called without parameters and parameters added later to command.

Returns

DbCommand

Initialized command instance.

SetParameter(DataConnection, DbParameter, string, DbDataType, object?)

public override void SetParameter(DataConnection dataConnection, DbParameter parameter, string name, DbDataType dataType, object? value)

Parameters

dataConnection DataConnection
parameter DbParameter
name string
dataType DbDataType
value object

SetParameterType(DataConnection, DbParameter, DbDataType)

protected override void SetParameterType(DataConnection dataConnection, DbParameter parameter, DbDataType dataType)

Parameters

dataConnection DataConnection
parameter DbParameter
dataType DbDataType