Class OracleSchemaProvider

Namespace

LinqToDB.Internal.DataProvider.Oracle

Assembly

linq2db.dll

public class OracleSchemaProvider : SchemaProviderBase, ISchemaProvider

Inheritance

object

SchemaProviderBase

OracleSchemaProvider

Implements

ISchemaProvider

Inherited Members

SchemaProviderBase.IncludedSchemas

SchemaProviderBase.ExcludedSchemas

SchemaProviderBase.IncludedCatalogs

SchemaProviderBase.ExcludedCatalogs

SchemaProviderBase.GenerateChar1AsString

SchemaProviderBase.DataTypesSchema

SchemaProviderBase.BuildSchemaFilter(GetSchemaOptions, string, Action<StringBuilder, string>)

SchemaProviderBase.ForeignKeyColumnComparison(string)

SchemaProviderBase.GetHashSet(string[], IEqualityComparer<string>)

SchemaProviderBase.GetProviderSpecificTables(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetProviderSpecificProcedures(DataConnection)

SchemaProviderBase.LoadProcedureTableSchema(DataConnection, GetSchemaOptions, ProcedureSchema, string, List<TableSchema>)

SchemaProviderBase.BuildProcedureParameter(ParameterSchema)

SchemaProviderBase.GetDataType(string, DataType?, GetSchemaOptions)

SchemaProviderBase.GetDataTypeByProviderDbType(int, GetSchemaOptions)

SchemaProviderBase.GetProcedureSchema(DataConnection, string, CommandType, DataParameter[], GetSchemaOptions)

SchemaProviderBase.InitProvider(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetDataTypes(DataConnection)

SchemaProviderBase.ToValidName(string)

SchemaProviderBase.ToTypeName(Type, bool)

SchemaProviderBase.ProcessSchema(DatabaseSchema, GetSchemaOptions)

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Constructors

OracleSchemaProvider(OracleDataProvider)

public OracleSchemaProvider(OracleDataProvider provider)

Parameters

provider OracleDataProvider

Properties

GetProcedureSchemaExecutesProcedure

If true, provider doesn't support schema-only procedure execution and will execute procedure for real.

protected override bool GetProcedureSchemaExecutesProcedure { get; }

Property Value

bool

Methods

BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema, string)

Builds table function call command.

protected override string BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema procedure, string commandText)

Parameters

procedure ProcedureSchema

commandText string

Returns

string

GetColumns(DataConnection, GetSchemaOptions)

protected override List<ColumnInfo> GetColumns(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<ColumnInfo>

GetDataSourceName(DataConnection)

protected override string GetDataSourceName(DataConnection dbConnection)

Parameters

dbConnection DataConnection

Returns

string

GetDataType(string?, string?, int?, int?, int?)

protected override DataType GetDataType(string? dataType, string? columnType, int? length, int? precision, int? scale)

Parameters

dataType string

columnType string

length int?

precision int?

scale int?

Returns

DataType

GetDatabaseName(DataConnection)

protected override string GetDatabaseName(DataConnection dbConnection)

Parameters

dbConnection DataConnection

Returns

string

GetDbType(GetSchemaOptions, string?, DataTypeInfo?, int?, int?, int?, string?, string?, string?)

protected override string? GetDbType(GetSchemaOptions options, string? columnType, DataTypeInfo? dataType, int? length, int? precision, int? scale, string? udtCatalog, string? udtSchema, string? udtName)

Parameters

options GetSchemaOptions

columnType string

dataType DataTypeInfo

length int?

precision int?

scale int?

udtCatalog string

udtSchema string

udtName string

Returns

string

GetForeignKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

protected override IReadOnlyCollection<ForeignKeyInfo> GetForeignKeys(DataConnection dataConnection, IEnumerable<TableSchema> tables, GetSchemaOptions options)

Parameters

dataConnection DataConnection

tables IEnumerable<TableSchema>

options GetSchemaOptions

Returns

IReadOnlyCollection<ForeignKeyInfo>

GetPrimaryKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

protected override IReadOnlyCollection<PrimaryKeyInfo> GetPrimaryKeys(DataConnection dataConnection, IEnumerable<TableSchema> tables, GetSchemaOptions options)

Parameters

dataConnection DataConnection

tables IEnumerable<TableSchema>

options GetSchemaOptions

Returns

IReadOnlyCollection<PrimaryKeyInfo>

GetProcedureParameters(DataConnection, IEnumerable<ProcedureInfo>, GetSchemaOptions)

protected override List<ProcedureParameterInfo> GetProcedureParameters(DataConnection dataConnection, IEnumerable<ProcedureInfo> procedures, GetSchemaOptions options)

Parameters

dataConnection DataConnection

procedures IEnumerable<ProcedureInfo>

options GetSchemaOptions

Returns

List<ProcedureParameterInfo>

GetProcedureResultColumns(DataTable, GetSchemaOptions)

protected override List<ColumnSchema> GetProcedureResultColumns(DataTable resultTable, GetSchemaOptions options)

Parameters

resultTable DataTable

options GetSchemaOptions

Returns

List<ColumnSchema>

GetProcedures(DataConnection, GetSchemaOptions)

protected override List<ProcedureInfo>? GetProcedures(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<ProcedureInfo>

GetProviderSpecificType(string?)

protected override string? GetProviderSpecificType(string? dataType)

Parameters

dataType string

Returns

string

GetProviderSpecificTypeNamespace()

protected override string GetProviderSpecificTypeNamespace()

Returns

string

GetSchema(DataConnection, GetSchemaOptions?)

Returns database schema. Note that it is recommended to call this method outside of transaction as some providers do not support it or behave incorrectly. At least following providers shouldn't be called in transaction:

• MySQL;
• Microsoft SQL Server;
• Sybase;
• DB2.

public override DatabaseSchema GetSchema(DataConnection dataConnection, GetSchemaOptions? options = null)

Parameters

dataConnection DataConnection

Data connection to use to read schema from.

options GetSchemaOptions

Schema read configuration options.

Returns

DatabaseSchema

Returns database schema information.

GetSystemType(string?, string?, DataTypeInfo?, int?, int?, int?, GetSchemaOptions)

protected override Type? GetSystemType(string? dataType, string? columnType, DataTypeInfo? dataTypeInfo, int? length, int? precision, int? scale, GetSchemaOptions options)

Parameters

dataType string

columnType string

dataTypeInfo DataTypeInfo

length int?

precision int?

scale int?

options GetSchemaOptions

Returns

Type

GetTables(DataConnection, GetSchemaOptions)

protected override List<TableInfo> GetTables(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<TableInfo>