Class SqlProviderOracle

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

SqlProvider for Oracle databases.

public class SqlProviderOracle : SqlProvider

Inheritance

object

SqlProvider

SqlProviderOracle

Inherited Members

SqlProvider.GlobalPrefix

SqlProvider.ReplaceDecimalPlaceholders(string)

SqlProvider.CreateParamMap(SqlParams)

SqlProvider.FindParam(Dictionary<string, SqlParam>, string, string)

SqlProvider.GetNativeParameterName(string)

SqlProvider.GetSqlParameterToken(string)

SqlProvider.CreateDbParameter(DbCommand, SqlParam)

SqlProvider.PrepareCommand(DbCommand, string, SqlParams)

SqlProvider.DecimalWithArgsSql(string)

SqlProvider.Log(Exception, string, object[], MemTable)

SqlProvider.FormatSqlLogValue(object)

SqlProvider.FormatSqlParameters(DbParameterCollection)

SqlProvider.CanLogSql(string)

SqlProvider.LogSql(DbCommand)

SqlProvider.CreateSqlParams(string, params object[])

SqlProvider.WaitUntilDatabaseReady(string, int, int)

SqlProvider.ReplaceDataTypePlaceholders(string)

SqlProvider.CreateConnectionStringBuilder(string)

SqlProvider.GetDatabaseName(string)

SqlProvider.CreateConnection(string)

SqlProvider.CreateCommand(DbConnection, string, params object[])

SqlProvider.CreateCommand(DbConnection, string, SqlParams)

SqlProvider.CanConnect(string, bool)

SqlProvider.DatabaseExists(string)

SqlProvider.EnsureConnection(string)

SqlProvider.OpenConnection(DbConnectionInfo)

SqlProvider.OpenConnection(string)

SqlProvider.BeginTransactionContext(DbConnectionInfo)

SqlProvider.BeginTransactionContext(string)

SqlProvider.NormalizeConnectionString(string)

SqlProvider.CreateDatabase(string)

SqlProvider.Select(DbConnectionInfo, string)

SqlProvider.Select(DbConnectionInfo, string, params object[])

SqlProvider.Select(string, string)

SqlProvider.Select(string, string, params object[])

SqlProvider.Select(string, string, int, params object[])

SqlProvider.Select(DbTransaction, string, int, params object[])

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string)

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, int, params object[])

SqlProvider.SelectTo(DbTransaction, MemTable, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, string)

SqlProvider.ExecSql(DbConnectionInfo, string, params object[])

SqlProvider.ExecSql(string, string)

SqlProvider.ExecSql(string, string, params object[])

SqlProvider.ExecSql(string, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, IEnumerable<string>)

SqlProvider.ExecSql(string, IEnumerable<string>)

SqlProvider.ExecSql(DbTransaction, string)

SqlProvider.ExecSql(DbTransaction, string, params object[])

SqlProvider.ExecSql(DbTransaction, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, Action<DbTransaction>)

SqlProvider.ExecSql(string, Action<DbTransaction>)

SqlProvider.SelectResults(string, string)

SqlProvider.SelectResults(string, string, params object[])

SqlProvider.SelectResults(DbTransaction, string, int, params object[])

SqlProvider.SelectResult(string, string)

SqlProvider.SelectResult(string, string, object)

SqlProvider.SelectResult(string, string, object, params object[])

SqlProvider.SelectResult(DbTransaction, string, int, object, params object[])

SqlProvider.IntegerResult(string, string, int)

SqlProvider.IntegerResult(string, string, int, params object[])

SqlProvider.IntegerResult(DbTransaction, string, int, int, params object[])

SqlProvider.SelectForUpdateSql(string, string)

SqlProvider.SelectForUpdate(DbTransaction, string, string, object)

SqlProvider.SelectForUpdate(DbTransaction, string, string, int, object)

SqlProvider.SelectIncrementLocked(DbConnectionInfo, string, string, object, string)

SqlProvider.SelectIncrementLocked(string, string, string, object, string, int)

SqlProvider.SelectIncrementLocked(DbTransaction, string, string, object, string, int)

SqlProvider.NormalizeRowLimit(int)

SqlProvider.QuoteName(string)

SqlProvider.Concat(params string[])

SqlProvider.GetServerDateTime(DbConnectionInfo)

SqlProvider.SupportsAlterTableType(AlterTableType)

SqlProvider.AddColumnSql(string, string)

SqlProvider.DropColumnSql(string, string)

SqlProvider.SetDefaultBeforeNotNullUpdateSql(string, string, string, bool)

SqlProvider.AddUniqueConstraintSql(string, string, string)

SqlProvider.DropUniqueConstraintSql(string, string)

SqlProvider.AddForeignKeySql(string, string, string, string, string)

SqlProvider.DropForeignKeySql(string, string)

SqlProvider.LastId(DbTransaction, string)

SqlProvider.Name

SqlProvider.Factory

SqlProvider.ServerType

SqlProvider.ConnectionStringAdapter

SqlProvider.PositionalParameters

SqlProvider.ConnectionStringTemplate

SqlProvider.SupportsTransactions

SqlProvider.SupportedAlterTableTypes

SqlProvider.DefaultCommandTimeoutSeconds

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

TypeExtensions.InheritsFrom(object, Type)

Properties

AutoIncSql

Keyword, used in replacing a placeholder

public override string AutoIncSql { get; }

Property Value

string

BlobSql

Keyword, used in replacing a placeholder

public override string BlobSql { get; }

Property Value

string

BlobTextSql

Keyword, used in replacing a placeholder

public override string BlobTextSql { get; }

Property Value

string

BoolSql

Keyword, used in replacing a placeholder

public override string BoolSql { get; }

Property Value

string

CanCreateDatabases

True if this provider can create databases.

public override bool CanCreateDatabases { get; }

Property Value

bool

DatabaseKeys

A list of strings used as database name key in connection strings.

public override string[] DatabaseKeys { get; }

Property Value

string[]

DateSql

Keyword, used in replacing a placeholder

public override string DateSql { get; }

Property Value

string

DateTimeSql

Keyword, used in replacing a placeholder

public override string DateTimeSql { get; }

Property Value

string

DecimalSql

Keyword, used in replacing a placeholder

public override string DecimalSql { get; }

Property Value

string

Description

The description of this sql provider

public override string Description { get; }

Property Value

string

FloatSql

Keyword, used in replacing a placeholder

public override string FloatSql { get; }

Property Value

string

LastIdSql

The keyword that can be used to return the last inserted id in an SQL statement.

public override string LastIdSql { get; }

Property Value

string

NBlobTextSql

Keyword, used in replacing a placeholder

public override string NBlobTextSql { get; }

Property Value

string

NVarcharSql

Keyword, used in replacing a placeholder

public override string NVarcharSql { get; }

Property Value

string

NativePrefix

The Oracle prefix for native parameters.

public override string NativePrefix { get; }

Property Value

string

NotNullSql

Keyword, used in replacing a placeholder

public override string NotNullSql { get; }

Property Value

string

NullSql

Keyword, used in replacing a placeholder

public override string NullSql { get; }

Property Value

string

ObjectEndDelimiter

The Oracle delimiter for object names.

public override string ObjectEndDelimiter { get; }

Property Value

string

ObjectStartDelimiter

The Oracle delimiter for object names.

public override string ObjectStartDelimiter { get; }

Property Value

string

OidMode

The OID mode this provider supports.

public override OidMode OidMode { get; }

Property Value

OidMode

PasswordKeys

A list of strings used as password key in connection strings.

public override string[] PasswordKeys { get; }

Property Value

string[]

PrimaryKeySql

Keyword, used in replacing a placeholder

public override string PrimaryKeySql { get; }

Property Value

string

ServerDateTimeSql

The keyword that can be used to return the current datetime in an SQL statement.

public override string ServerDateTimeSql { get; }

Property Value

string

ServerKeys

A list of strings used as server name key in connection strings.

public override string[] ServerKeys { get; }

Property Value

string[]

SuperUser

The Oracle super user name.

public override string SuperUser { get; }

Property Value

string

SuperUserPassword

The Oracle super user password.

public override string SuperUserPassword { get; }

Property Value

string

SupportsAutoIncFields

True if this provider supports auto-increment fields.

public override bool SupportsAutoIncFields { get; }

Property Value

bool

SupportsGenerators

True if this provider supports generators.

public override bool SupportsGenerators { get; }

Property Value

bool

UserNameKeys

A list of strings used as user name key in connection strings.

public override string[] UserNameKeys { get; }

Property Value

string[]

VarcharSql

Keyword, used in replacing a placeholder

public override string VarcharSql { get; }

Property Value

string

Methods

ApplyRowLimit(string, int)

Applies a row limit to the SqlText

public override string ApplyRowLimit(string SqlText, int RowLimit)

Parameters

SqlText string

RowLimit int

Returns

string

CreateConnectionString(string, string, string, string)

Creates a connection string

public override string CreateConnectionString(string Server, string Database, string UserName, string Password)

Parameters

Server string

Database string

UserName string

Password string

Returns

string

CreateGenerator(string, string)

Creates the GeneratorName generator to the database.

public override void CreateGenerator(string ConnectionString, string GeneratorName)

Parameters

ConnectionString string

GeneratorName string

DropColumnDefaultSql(string, string)

Returns an "alter column" SQL statement.

public override string DropColumnDefaultSql(string TableName, string ColumnName)

Parameters

TableName string

ColumnName string

Returns

string

DropNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string DropNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

GeneratorExists(string, string)

Returns true if the GeneratorName exists in a database.

public override bool GeneratorExists(string ConnectionString, string GeneratorName)

Parameters

ConnectionString string

GeneratorName string

Returns

bool

GetServerDateTime(string)

Returns the current date and time of the database server

public override DateTime GetServerDateTime(string ConnectionString)

Parameters

ConnectionString string

Returns

DateTime

NextIdByGenerator(DbTransaction, string)

Returns the next value of the GeneratorName generator.

public override int NextIdByGenerator(DbTransaction Transaction, string GeneratorName)

Parameters

Transaction DbTransaction

GeneratorName string

Returns

int

QSDate(DateTime)

Quotes and formats a date value as a string, properly for use with an Sql statement

public override string QSDate(DateTime Value)

Parameters

Value DateTime

Returns

string

QSDateTime(DateTime)

Quotes and formats a date-time value as a string, properly for use with an Sql statement

public override string QSDateTime(DateTime Value)

Parameters

Value DateTime

Returns

string

RenameColumnSql(string, string, string)

Returns an "alter column" SQL statement.

public override string RenameColumnSql(string TableName, string ColumnName, string NewColumnName)

Parameters

TableName string

ColumnName string

NewColumnName string

Returns

string

SetColumnDefaultSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnDefaultSql(string TableName, string ColumnName, string DefaultExpression)

Parameters

TableName string

ColumnName string

DefaultExpression string

Returns

string

SetColumnLengthSql(string, string, string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnLengthSql(string TableName, string ColumnName, string DataType, string Required, string DefaultExpression)

Parameters

TableName string

ColumnName string

DataType string

Required string

DefaultExpression string

Returns

string

SetGeneratorTo(string, string, int)

Attempts to set a generator/sequencer to Value.

DANGEROOUS.

public override void SetGeneratorTo(string ConnectionString, string GeneratorName, int Value)

Parameters

ConnectionString string

GeneratorName string

Value int

SetNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string

SetTableGeneratorTo(string, string, int)

Attempts to set a generator/sequencer or identity column to Value.

VERY DANGEROOUS.

public override void SetTableGeneratorTo(string ConnectionString, string TableName, int Value)

Parameters

ConnectionString string

TableName string

Value int