dotConnect for Oracle Documentation
OracleConnection Class Members
See Also  Properties  Methods  Events support@devart.com
Devart.Data.Oracle Namespace : OracleConnection Class


The following tables list the members exposed by OracleConnection.

Public Constructors

 NameDescription
public ConstructorOracleConnection ConstructorOverloaded. Initializes a new instance of the OracleConnection class.Initializes a new instance of the OracleConnection class.  
Top

Public Properties

 NameDescription
public PropertyActionNameGets or sets the action name for the connection.  
public PropertyAutoCommitDetermines whether modifications will be committed automatically at the server or not.  
public PropertyClientIdThis property specifies the client identifier for the connection. It helps to make audition of the client connections and gives an opportunity to distinguish between the applications connecting to.  
public PropertyClientInfoGets or sets the client information for the connection.  
public PropertyClientVersionReturns version of Oracle client used for this connection.  
public PropertyConnectionStringGets or sets the string used to open an Oracle server database.  
public PropertyConnectionTimeoutGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
public PropertyConnectModeOpens a session with administrative privileges SYSDBA or SYSOPER.  
public PropertyContainerGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertyDataSourceGets the name of the database server to which to connect. (Inherited from System.Data.Common.DbConnection)
public PropertyDirectIndicates whether Direct mode of communicating with server should be used.  
public PropertyHomeGets or sets Oracle Home to be used.  
public Propertystatic (Shared in Visual Basic)HomesGets the list of all available Oracle homes.  
public PropertyInDistributedTransactionIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
public PropertyLogicalTransactionIdGets the logical transaction ID (LTXID) of the last executed translation. Can be used for determining the outcome of the last transaction, opened by this connection, following an outage. Requires Oracle 12c and works only in OCI mode.  
public PropertyModuleNameGets or sets the module name for the connection.  
public PropertyNameGets or sets name of the component.  
public PropertyNumberMappingsGets or sets the collection of number mappings used for this connection.  
public PropertyOracleLogicalTransactionGets an OracleLogicalTransaction object, which allows you to determine whether the running transaction during the last database outage was successfully committed and completed.  
public PropertyOwnerGets or sets a form or other container that the OracleConnection instance belongs to.  
public PropertyPassParametersByNameDetermines whether parameters will be passed by name to the stored procedure calls.  
public PropertyPasswordGets or sets the user's password to connect.  
public PropertyPortGets or sets number of a port to communicate with listener on the server.  
public PropertyServerGets or sets the name of TNS alias of the Oracle database to which to connect.  
public PropertyServerTypeIndicates whether the connected database is an Oracle database or a TimesTen database.  
public PropertyServerVersionGets a string containing the version of the instance of Oracle to which the client is connected.  
public PropertyServiceNameGets or sets an alias to an Oracle database instance (or many instances) to use in the OracleConnection.Direct mode.  
public PropertyShortServerVersionGets the version of the instance of Oracle Database, the OracleConnection object is connected to, as a System.Version object.  
public PropertySidGets or sets a unique name for an Oracle database instance.  
public PropertySiteGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertyStateGets the current state of the connection.  
public PropertyTrimFixedCharSpecifies whether to trim trailing spaces when reading data from fixed-length string data types (CHAR, NCHAR).  
public PropertyUnicodeGets or sets a value indicating whether the UTF16 charset will be used.  
public PropertyUserIdGets or sets the name of the user to connect.  
Top

Public Methods

 NameDescription
public MethodBeginOpenStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
public MethodBeginTransactionOverloaded. Begins a transaction at the database.  
public MethodChangeDatabaseChanges the current database for an open connection. (Inherited from System.Data.Common.DbConnection)
public MethodChangePasswordChanges the password for the specified user.  
public Methodstatic (Shared in Visual Basic)ClearAllPoolsOverloaded. Clears all pools associated with the connection.  
public Methodstatic (Shared in Visual Basic)ClearPoolClears the pool matching ConnectionString of provided OracleConnection object.  
public MethodCloneCreates a new object that is a copy of the current instance.  
public MethodCloseOverridden. Closes the connection to the database. This is the preferred method of closing any open connection.  
public MethodCommitCommits the database transaction.  
public MethodCreateCommandOverloaded. Creates and returns a OracleCommand object associated with the OracleConnection.  
public MethodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
public MethodDisposeReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public MethodEndOpenEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
public MethodEnlistTransactionEnlists in the specified transaction. (Inherited from System.Data.Common.DbConnection)
public MethodGetDatabaseInfoOverloaded. Gets OracleGlobalization settings for the current database.  
public MethodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodGetLogicalTransactionStatusReturns the status of the specified transaction. Requires Oracle 12c and works only in OCI mode.  
public MethodGetNativeHandleGets a native handle for the OracleConnection.  
public MethodGetSchemaOverloaded. Returns schema information for the data source of this System.Data.Common.DbConnection. (Inherited from System.Data.Common.DbConnection)
public Methodstatic (Shared in Visual Basic)GetServerListOverloaded. Returns an array of available TNS aliases.  
public MethodGetSessionInfoOverloaded. Populates an OracleGlobalization object with client side information.  
public MethodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodOpenOverloaded. Opens connection with Proxy Authentication mechanism.  
public MethodPingDetermines whether connection to Oracle server is valid.  
public MethodPurgeStatementCacheClears OCI statement cache for the connection.  
public MethodRollbackRolls back a transaction from a pending state.  
public MethodSetDbmsApplicationInfoThis method uses the DBMS_APPLICATION_INFO package to record the names of the module and action performed and the client information to Oracle database in order to ease tracking of the application actions, performance, and resource usage.  
public MethodSetSessionInfoSets Oracle globalization settings for the current connection.  
Top

Public Events

 NameDescription
public EventDisposedOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
public EventErrorOccurs when Oracle returns an error message.  
public EventFailoverOccurs when Oracle Failover mechanism takes place.  
public EventHAEventOccurs when a HA event happens.  
public EventInfoMessageOccurs when Oracle returns a warning or informational message.  
public EventStateChangeOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
public EventTransactionStateChangedOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
public EventTransactionStateChangingOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
Top

See Also