Table of Contents

Class BaseOracleConnectionProvider

Namespace
DevExpress.Xpo.DB
Assembly
DevExpress.Xpo.v24.1.dll
public abstract class BaseOracleConnectionProvider : ConnectionProviderSql
Inheritance
BaseOracleConnectionProvider
Derived

Constructors

BaseOracleConnectionProvider(IDbConnection, AutoCreateOption) 

public BaseOracleConnectionProvider(IDbConnection connection, AutoCreateOption autoCreateOption)

Parameters

connection IDbConnection
autoCreateOption AutoCreateOption

Fields

IsUtf8Charset 

public bool IsUtf8Charset

Field Value

bool

MaximumBinarySize 

public const int MaximumBinarySize = 2000

Field Value

int

MaximumStringSize 

public const int MaximumStringSize = 2000

Field Value

int

ObjectsOwner 

public string ObjectsOwner

Field Value

string

SysUsersAvailable 

public bool SysUsersAvailable

Field Value

bool

Properties

NativeSkipTakeSupported 

public override bool NativeSkipTakeSupported { get; }

Property Value

bool

UpdateSchemaFormatter 

protected override UpdateSchemaSqlFormatterHelper UpdateSchemaFormatter { get; }

Property Value

UpdateSchemaSqlFormatterHelper

Methods

CheckSysUsers() 

public virtual bool CheckSysUsers()

Returns

bool

ClearDatabase(IDbCommand) 

public void ClearDatabase(IDbCommand command)

Parameters

command IDbCommand

CollectTablesToCreate(ICollection) 

public override ICollection CollectTablesToCreate(ICollection tables)

Parameters

tables ICollection

Returns

ICollection

CreateDataBase() 

protected override void CreateDataBase()

CreateSchemaComparer() 

protected override DBSchemaComparerSql CreateSchemaComparer()

Returns

DBSchemaComparerSql

CreateTable(DBTable) 

public override void CreateTable(DBTable table)

Parameters

table DBTable

FormatBinary(BinaryOperatorType, string, string) 

public override string FormatBinary(BinaryOperatorType operatorType, string leftOperand, string rightOperand)

Parameters

operatorType BinaryOperatorType
leftOperand string
rightOperand string

Returns

string

FormatColumn(string) 

public override string FormatColumn(string columnName)

Parameters

columnName string

Returns

string

FormatColumn(string, string) 

public override string FormatColumn(string columnName, string tableAlias)

Parameters

columnName string
tableAlias string

Returns

string

FormatConstraint(string) 

public override string FormatConstraint(string constraintName)

Parameters

constraintName string

Returns

string

FormatDelete(string, string) 

public override string FormatDelete(string tableName, string whereClause)

Parameters

tableName string
whereClause string

Returns

string

FormatFunction(FunctionOperatorType, params string[]) 

public override string FormatFunction(FunctionOperatorType operatorType, params string[] operands)

Parameters

operatorType FunctionOperatorType
operands string[]

Returns

string

FormatFunction(ProcessParameter, FunctionOperatorType, params object[]) 

public override string FormatFunction(ProcessParameter processParameter, FunctionOperatorType operatorType, params object[] operands)

Parameters

processParameter ProcessParameter
operatorType FunctionOperatorType
operands object[]

Returns

string

FormatInsert(string, string, string) 

public override string FormatInsert(string tableName, string fields, string values)

Parameters

tableName string
fields string
values string

Returns

string

FormatInsertDefaultValues(string) 

public override string FormatInsertDefaultValues(string tableName)

Parameters

tableName string

Returns

string

FormatOrder(string, SortingDirection) 

public override string FormatOrder(string sortProperty, SortingDirection direction)

Parameters

sortProperty string
direction SortingDirection

Returns

string

FormatSelect(string, string, string, string, string, string, int, int) 

public override string FormatSelect(string selectedPropertiesSql, string fromSql, string whereSql, string orderBySql, string groupBySql, string havingSql, int skipSelectedRecords, int topSelectedRecords)

Parameters

selectedPropertiesSql string
fromSql string
whereSql string
orderBySql string
groupBySql string
havingSql string
skipSelectedRecords int
topSelectedRecords int

Returns

string

FormatTable(string, string) 

public override string FormatTable(string schema, string tableName)

Parameters

schema string
tableName string

Returns

string

FormatTable(string, string, string) 

public override string FormatTable(string schema, string tableName, string tableAlias)

Parameters

schema string
tableName string
tableAlias string

Returns

string

FormatUpdate(string, string, string) 

public override string FormatUpdate(string tableName, string sets, string whereClause)

Parameters

tableName string
sets string
whereClause string

Returns

string

GenerateBatchedIdentityInsert(InsertStatement, string, TaggedParametersHolder, Dictionary<OperandValue, string>) 

protected virtual Query GenerateBatchedIdentityInsert(InsertStatement insert, string identityParameterName, TaggedParametersHolder identitiesByTag, Dictionary<OperandValue, string> parameters)

Parameters

insert InsertStatement
identityParameterName string
identitiesByTag TaggedParametersHolder
parameters Dictionary<OperandValue, string>

Returns

Query

GenerateStoredProcedures(DBTable, out string) 

public override string GenerateStoredProcedures(DBTable table, out string dropLines)

Parameters

table DBTable
dropLines string

Returns

string

GetCurrentUser() 

public virtual string GetCurrentUser()

Returns

string

GetIdentity(InsertStatement, TaggedParametersHolder) 

protected override long GetIdentity(InsertStatement root, TaggedParametersHolder identitiesByTag)

Parameters

root InsertStatement
identitiesByTag TaggedParametersHolder

Returns

long

GetIdentityAsync(InsertStatement, TaggedParametersHolder, AsyncOperationIdentifier, CancellationToken) 

protected override Task<long> GetIdentityAsync(InsertStatement root, TaggedParametersHolder identitiesByTag, AsyncOperationIdentifier asyncOperationId, CancellationToken cancellationToken)

Parameters

root InsertStatement
identitiesByTag TaggedParametersHolder
asyncOperationId AsyncOperationIdentifier
cancellationToken CancellationToken

Returns

Task<long>

GetObjectNameEffectiveLength(string) 

protected override int GetObjectNameEffectiveLength(string objectName)

Parameters

objectName string

Returns

int

GetParameterName(OperandValue, int, ref bool) 

public override string GetParameterName(OperandValue parameter, int index, ref bool createParameter)

Parameters

parameter OperandValue
index int
createParameter bool

Returns

string

GetSafeNameTableMaxLength() 

protected override int GetSafeNameTableMaxLength()

Returns

int

GetSeqName(string) 

protected virtual string GetSeqName(string tableName)

Parameters

tableName string

Returns

string

GetSeqViewName(string) 

protected virtual string GetSeqViewName(string tableName)

Parameters

tableName string

Returns

string

GetSqlCreateColumnFullAttributes(DBTable, DBColumn) 

public override string GetSqlCreateColumnFullAttributes(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnFullAttributes(DBTable, DBColumn, bool) 

public override string GetSqlCreateColumnFullAttributes(DBTable table, DBColumn column, bool forTableCreate)

Parameters

table DBTable
column DBColumn
forTableCreate bool

Returns

string

GetSqlCreateColumnTypeForBoolean(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForBoolean(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForByte(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForByte(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForByteArray(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForByteArray(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForChar(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForChar(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForDateTime(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForDateTime(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForDecimal(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForDecimal(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForDouble(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForDouble(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForGuid(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForGuid(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt16(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForInt16(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt32(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForInt32(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt64(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForInt64(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForSByte(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForSByte(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForSingle(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForSingle(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForString(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForString(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt16(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForUInt16(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt32(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForUInt32(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt64(DBTable, DBColumn) 

protected override string GetSqlCreateColumnTypeForUInt64(DBTable table, DBColumn column)

Parameters

table DBTable
column DBColumn

Returns

string

GetStorageTablesList(bool) 

public override string[] GetStorageTablesList(bool includeViews)

Parameters

includeViews bool

Returns

string[]

GetStoredProcedures() 

public override DBStoredProcedure[] GetStoredProcedures()

Returns

DBStoredProcedure[]

GetTableSchema(DBTable, bool, bool) 

public override void GetTableSchema(DBTable table, bool checkIndexes, bool checkForeignKeys)

Parameters

table DBTable
checkIndexes bool
checkForeignKeys bool

IsBatchingForbidden(ModificationStatement) 

protected virtual bool IsBatchingForbidden(ModificationStatement dml)

Parameters

dml ModificationStatement

Returns

bool

PrepareDelegates() 

protected virtual void PrepareDelegates()

ProcessClearDatabase() 

protected override void ProcessClearDatabase()

ProcessModifyData(params ModificationStatement[]) 

protected override ModificationResult ProcessModifyData(params ModificationStatement[] dmlStatements)

Parameters

dmlStatements ModificationStatement[]

Returns

ModificationResult

ProcessModifyDataAsync(AsyncOperationIdentifier, CancellationToken, params ModificationStatement[]) 

protected override Task<ModificationResult> ProcessModifyDataAsync(AsyncOperationIdentifier asyncOperationId, CancellationToken cancellationToken, params ModificationStatement[] dmlStatements)

Parameters

asyncOperationId AsyncOperationIdentifier
cancellationToken CancellationToken
dmlStatements ModificationStatement[]

Returns

Task<ModificationResult>