OracleConnection Properties

OracleConnection properties are listed in Table 6-46

Table 6-46 OracleConnection Properties

Property Description

ActionName

Specifies the action name for the connection

ClientId

Specifies the client identifier for the connection

ClientInfo

Specifies the client information for the connection

ConnectionString

Specifies connection information used to connect to an Oracle database

ConnectionTimeout

Indicates the maximum amount of time that the Open method can take to obtain a pooled connection before the request is terminated

ConnectionType

Determines whether a particular connection object is associated with a TimesTen database connection, an Oracle database connection, or no physical connection

Not Available in ODP.NET, Managed Driver and ODP.NET Core

Container

Inherited from System.ComponentModel.Component

Credential

Used to get or set an OracleCredential object on the connection

Database

Not Supported

DatabaseDomainName

Specifies the name of the database domain to which the connection is set

DatabaseEditionName

Sets or gets the edition name for the OracleConnection object

DatabaseName

Specifies the name of the database to which the connection is set

DataSource

Specifies the Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect

DRCPConnectionClass

Specifies a logical name that identifies the DRCP connection pool that the ODP.NET connection will use

DRCPPurity

Specifies whether an application can reuse a pooled session (Pooled) or must use a new session (New)

HostName

Specifies the name of the host to which the connection is set

InstanceName

Specifies the name of the instance to which the connection is set

ModuleName

Specifies the module name for the connection

PDBName

Used to set and get the name of the pluggable database to which the session is connected to

ServerVersion

Specifies the version number of the Oracle database to which the OracleConnection has established a connection

ServiceName

Specifies the name of the service to which the connection is set

Site

Inherited from System.ComponentModel.Component

State

Specifies the current state of the connection

StatementCacheSize

Specifies the current size of the statement cache associated with this connection

SwitchedConnection

If the returned pooled connection changed its service name (ServiceName) or pluggable database (PDBName) in order to connect to the desired pluggable database, then this property will consider the connection switched.