Class OracleTools

Namespace

LinqToDB.DataProvider.Oracle

Assembly

linq2db.dll

public static class OracleTools

Inheritance

object

OracleTools

Properties

AutoDetectProvider

public static bool AutoDetectProvider { get; set; }

Property Value

bool

DefaultBulkCopyType

[Obsolete("Use OracleOptions.Default.BulkCopyType instead.")]
public static BulkCopyType DefaultBulkCopyType { get; set; }

Property Value

BulkCopyType

DefaultVersion

public static OracleVersion DefaultVersion { get; set; }

Property Value

OracleVersion

DontEscapeLowercaseIdentifiers

Gets or sets flag to tell LinqToDB to quote identifiers, if they contain lowercase letters. Default value: false. This flag is added for backward compatibility and not recommended for use with new applications.

[Obsolete("Use OracleOptions.Default.DontEscapeLowercaseIdentifiers instead.")]
public static bool DontEscapeLowercaseIdentifiers { get; set; }

Property Value

bool

UseAlternativeBulkCopy

Specifies type of multi-row INSERT operation to generate for RowByRow bulk copy mode. Default value: InsertAll.

[Obsolete("Use OracleOptions.Default.AlternativeBulkCopy instead.")]
public static AlternativeBulkCopy UseAlternativeBulkCopy { get; set; }

Property Value

AlternativeBulkCopy

Methods

AsOracle<TSource>(ITable<TSource>)

[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IOracleSpecificTable<TSource> AsOracle<TSource>(this ITable<TSource> table) where TSource : notnull

Parameters

table ITable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

AsOracle<TSource>(IQueryable<TSource>)

[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IOracleSpecificQueryable<TSource> AsOracle<TSource>(this IQueryable<TSource> source) where TSource : notnull

Parameters

source IQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

CreateDataConnection(DbConnection, OracleVersion, OracleProvider)

public static DataConnection CreateDataConnection(DbConnection connection, OracleVersion version = OracleVersion.AutoDetect, OracleProvider provider = OracleProvider.Managed)

Parameters

connection DbConnection

version OracleVersion

provider OracleProvider

Returns

DataConnection

CreateDataConnection(DbTransaction, OracleVersion, OracleProvider)

public static DataConnection CreateDataConnection(DbTransaction transaction, OracleVersion version = OracleVersion.AutoDetect, OracleProvider provider = OracleProvider.Managed)

Parameters

transaction DbTransaction

version OracleVersion

provider OracleProvider

Returns

DataConnection

CreateDataConnection(string, OracleVersion, OracleProvider)

public static DataConnection CreateDataConnection(string connectionString, OracleVersion version = OracleVersion.AutoDetect, OracleProvider provider = OracleProvider.Managed)

Parameters

connectionString string

version OracleVersion

provider OracleProvider

Returns

DataConnection

GetDataProvider(OracleVersion, OracleProvider, string?)

public static IDataProvider GetDataProvider(OracleVersion version = OracleVersion.AutoDetect, OracleProvider provider = OracleProvider.Managed, string? connectionString = null)

Parameters

version OracleVersion

provider OracleProvider

connectionString string

Returns

IDataProvider

GetXmlData<T>(DataOptions, MappingSchema, IEnumerable<T>)

public static string GetXmlData<T>(DataOptions options, MappingSchema mappingSchema, IEnumerable<T> data)

Parameters

options DataOptions

mappingSchema MappingSchema

data IEnumerable<T>

Returns

string

Type Parameters

T

OracleXmlTable<T>(IDataContext, IEnumerable<T>)

public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, IEnumerable<T> data) where T : class

Parameters

dataContext IDataContext

data IEnumerable<T>

Returns

ITable<T>

Type Parameters

T

OracleXmlTable<T>(IDataContext, Func<string>)

public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, Func<string> xmlData) where T : class

Parameters

dataContext IDataContext

xmlData Func<string>

Returns

ITable<T>

Type Parameters

T

OracleXmlTable<T>(IDataContext, string)

public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, string xmlData) where T : class

Parameters

dataContext IDataContext

xmlData string

Returns

ITable<T>

Type Parameters

T