Class OracleProviderBase

Inheritance

System.Object

DbProvider

OracleProviderBase

ODPOracleProvider

OracleProvider

ODPOracleProvider

Inherited Members

DbProvider.SetDatabaseParameterTypeForClobText(IDbDataParameter, Boolean)

DbProvider.CreateCommand(IDbConnection)

DbProvider.TestConnection()

DbProvider.TestConnection(Exception)

DbProvider.GetDbVersion()

DbProvider.GetDbVersion(Boolean)

DbProvider.GetVersionFromString(String)

DbProvider.ParseConnectionString(String)

DbProvider.ConstructConnectionString(NameValueCollection)

DbProvider.CanBatchQueries

DbProvider.ConnectionString

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: FChoice.Common.Data

Assembly: FChoice.Common.dll

Syntax

public abstract class OracleProviderBase : DbProvider

Constructors

OracleProviderBase()

Declaration

protected OracleProviderBase()

Fields

CONN_STR_FORMAT

Declaration

protected const string CONN_STR_FORMAT = "Data Source={0};User Id={1};Password={2};{3}"

Field Value

Type	Description
System.String

ORACLE_DATE_FORMAT

Declaration

protected const string ORACLE_DATE_FORMAT = "yyyy-MM-dd HH:mm:ss"

Field Value

Type	Description
System.String

ORACLE_OUTPUT_DATE_FORMAT

Declaration

protected const string ORACLE_OUTPUT_DATE_FORMAT = "TO_DATE('{0}', 'yyyy-mm-dd hh24:mi:ss')"

Field Value

Type	Description
System.String

Properties

MaxInListItems

Declaration

public override int MaxInListItems { get; }

Property Value

Type	Description
System.Int32

Overrides

DbProvider.MaxInListItems

ProviderCanBatchQueries

Declaration

protected override bool ProviderCanBatchQueries { get; }

Property Value

Type	Description
System.Boolean

Overrides

DbProvider.ProviderCanBatchQueries

ProviderName

Declaration

public override string ProviderName { get; }

Property Value

Type	Description
System.String

Overrides

DbProvider.ProviderName

RequiresDbNameParameter

Declaration

public override bool RequiresDbNameParameter { get; }

Property Value

Type	Description
System.Boolean

Overrides

DbProvider.RequiresDbNameParameter

TypeMapper

Declaration

public override TypeMapper TypeMapper { get; }

Property Value

Type	Description
TypeMapper

Overrides

DbProvider.TypeMapper

Methods

AreLargeTextFieldsClobs()

Declaration

public virtual bool AreLargeTextFieldsClobs()

Returns

Type	Description
System.Boolean

CreateConnectionString(String, String, String, String, String)

Declaration

public override string CreateConnectionString(string dbServer, string dbName, string dbUser, string dbPass, string extraParams)

Parameters

Type	Name	Description
System.String	dbServer
System.String	dbName
System.String	dbUser
System.String	dbPass
System.String	extraParams

Returns

Type	Description
System.String

Overrides

DbProvider.CreateConnectionString(String, String, String, String, String)

CreateParameter(String, Object)

Declaration

public override IDbDataParameter CreateParameter(string name, object value)

Parameters

Type	Name	Description
System.String	name
System.Object	value

Returns

Type	Description
System.Data.IDbDataParameter

Overrides

DbProvider.CreateParameter(String, Object)

FormatDateLiteral(DateTime)

Declaration

public override string FormatDateLiteral(DateTime value)

Parameters

Type	Name	Description
System.DateTime	value

Returns

Type	Description
System.String

Overrides

DbProvider.FormatDateLiteral(DateTime)

GetAdapter()

Declaration

public override DbDataAdapter GetAdapter()

Returns

Type	Description
System.Data.Common.DbDataAdapter

Overrides

DbProvider.GetAdapter()

GetAdapter(IDbConnection)

Declaration

public override DbDataAdapter GetAdapter(IDbConnection conn)

Parameters

Type	Name	Description
System.Data.IDbConnection	conn

Returns

Type	Description
System.Data.Common.DbDataAdapter

Overrides

DbProvider.GetAdapter(IDbConnection)

GetAdapter(IDbConnection, String)

Declaration

public override DbDataAdapter GetAdapter(IDbConnection conn, string sqlStmt)

Parameters

Type	Name	Description
System.Data.IDbConnection	conn
System.String	sqlStmt

Returns

Type	Description
System.Data.Common.DbDataAdapter

Overrides

DbProvider.GetAdapter(IDbConnection, String)

GetAsStatement(String)

Declaration

public override string GetAsStatement(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

Overrides

DbProvider.GetAsStatement(String)

GetBadConTypeException(String, String)

Declaration

protected static Exception GetBadConTypeException(string actualType, string expectedType)

Parameters

Type	Name	Description
System.String	actualType
System.String	expectedType

Returns

Type	Description
System.Exception

GetBitwiseAndStatement(Object, Object)

Declaration

public override string GetBitwiseAndStatement(object operand1, object operand2)

Parameters

Type	Name	Description
System.Object	operand1
System.Object	operand2

Returns

Type	Description
System.String

Overrides

DbProvider.GetBitwiseAndStatement(Object, Object)

GetConnection()

Declaration

public override IDbConnection GetConnection()

Returns

Type	Description
System.Data.IDbConnection

Overrides

DbProvider.GetConnection()

GetConnection(String)

Declaration

public override IDbConnection GetConnection(string newConStr)

Parameters

Type	Name	Description
System.String	newConStr

Returns

Type	Description
System.Data.IDbConnection

Overrides

DbProvider.GetConnection(String)

GetDateStatement()

Declaration

public override string GetDateStatement()

Returns

Type	Description
System.String

Overrides

DbProvider.GetDateStatement()

GetDBDate()

Declaration

public override DateTime GetDBDate()

Returns

Type	Description
System.DateTime

Overrides

DbProvider.GetDBDate()

GetNlsFormat(OracleProviderBase)

Declaration

public static string GetNlsFormat(OracleProviderBase provider)

Parameters

Type	Name	Description
OracleProviderBase	provider

Returns

Type	Description
System.String

GetParameterNamePrefix()

Declaration

public override string GetParameterNamePrefix()

Returns

Type	Description
System.String

Overrides

DbProvider.GetParameterNamePrefix()

Initialize()

Declaration

protected override void Initialize()

Overrides

DbProvider.Initialize()

Load(XmlNodeList)

Declaration

protected override void Load(XmlNodeList configArguments)

Parameters

Type	Name	Description
System.Xml.XmlNodeList	configArguments

Overrides

DbProvider.Load(XmlNodeList)

PerformGetDbVersion()

Declaration

protected override Version PerformGetDbVersion()

Returns

Type	Description
System.Version

Overrides

DbProvider.PerformGetDbVersion()

PrepareParameter(IDbDataParameter, CommandType)

Declaration

public override void PrepareParameter(IDbDataParameter param, CommandType cmdType)

Parameters

Type	Name	Description
System.Data.IDbDataParameter	param
System.Data.CommandType	cmdType

Overrides

DbProvider.PrepareParameter(IDbDataParameter, CommandType)

PrepareSQLStatement(String, CommandType, DataParameterCollection)

Declaration

public override string PrepareSQLStatement(string sqlStmt, CommandType cmdType, DataParameterCollection commandParams)

Parameters

Type	Name	Description
System.String	sqlStmt
System.Data.CommandType	cmdType
DataParameterCollection	commandParams

Returns

Type	Description
System.String

Overrides

DbProvider.PrepareSQLStatement(String, CommandType, DataParameterCollection)

RemoveParameterNamePrefix(String)

Declaration

public override string RemoveParameterNamePrefix(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

Overrides

DbProvider.RemoveParameterNamePrefix(String)

ValidateConnectionParams(String, String, String, String)

Declaration

public override bool ValidateConnectionParams(string dbServer, string dbName, string dbUser, string dbPass)

Parameters

Type	Name	Description
System.String	dbServer
System.String	dbName
System.String	dbUser
System.String	dbPass

Returns

Type	Description
System.Boolean

Overrides

DbProvider.ValidateConnectionParams(String, String, String, String)