dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnection Class
Properties Methods Events

OracleConnection Class Members

The following tables list the members exposed by OracleConnection.

Public Constructors
 NameDescription
Public ConstructorOverloaded. Initializes a new instance of OracleConnection class.  
Top
Public Properties
 NameDescription
Public PropertyGets or sets the action name for the connection.  
Public PropertyDetermines whether modifications will be committed automatically at the server or not.  
Public PropertyThis 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 PropertyGets or sets the client information for the connection.  
Public PropertyReturns version of Oracle client used for this connection.  
Public PropertyGets or sets the string used to open an Oracle server database.  
Public PropertyGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
Public PropertyOpens a session with administrative privileges SYSDBA or SYSOPER.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets user credentials with a more securely stored password.  
Public PropertyGets or sets name of the server to which to connect. (Inherited from Devart.Common.DbConnectionBase)
Public Property  
Public PropertyIndicates whether Direct mode of communicating with server should be used.  
Public PropertyGets or sets Oracle Home to be used.  
Public Propertystatic (Shared in Visual Basic)Gets the list of all available Oracle homes.  
Public PropertyIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
Public PropertyGets 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 PropertyGets or sets the module name for the connection.  
Public PropertyGets or sets name of the component.  
Public PropertyGets or sets the collection of number mappings used for this connection.  
Public PropertyGets an OracleLogicalTransaction object, which allows you to determine whether the running transaction during the last database outage was successfully committed and completed.  
Public PropertyGets or sets a form or other container that the OracleConnection instance belongs to.  
Public PropertyDetermines whether parameters will be passed by name to the stored procedure calls.  
Public PropertyGets or sets the user's password to connect.  
Public PropertyGets or sets number of a port to communicate with listener on the server.  
Public PropertyGets or sets the name of TNS alias of the Oracle database to which to connect.  
Public PropertyIndicates whether the connected database is an Oracle database or a TimesTen database.  
Public PropertyRetrieves a string that contains the version of the Oracle instance the client is connected to.  
Public PropertyGets or sets an alias to an Oracle database instance (or many instances) to use in the OracleConnection.Direct mode.  
Public PropertyGets the version of the instance of Oracle Database, the OracleConnection object is connected to, as a System.Version object.  
Public PropertyGets or sets a unique name for an Oracle database instance.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets SshOptions object which is used to establish secure SSH connection with server in the Direct mode.  
Public PropertyGets or sets the SSL Certificate contents as a base64 encoded string.  
Public PropertyGets or sets the SSL Key contents as a base64 encoded string.  
Public PropertyGets or sets SslOptions object which is used to establish secure SSL/TLS connection with server in the Direct mode.  
Public PropertyGets or sets parameters for Oracle server certificate check.  
Public PropertyDetermines the location of the Oracle Wallet to get a certificate for connecting to Oracle in the Direct mode.  
Public PropertyGets the current state of the connection.  
Public PropertySpecifies whether to trim trailing spaces when reading data from fixed-length string data types (CHAR, NCHAR).  
Public PropertyGets or sets a value indicating whether the UTF16 charset will be used.  
Public PropertyGets or sets the name of the user to connect.  
Top
Public Methods
 NameDescription
Public MethodStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
Public MethodOverloaded. Begins a transaction at the database.  
Public MethodChanges the current schema associated with an open Devart.Common.DbConnectionBase. (Inherited from Devart.Common.DbConnectionBase)
Public MethodOverloaded. Changes the password for the userб specified in the connection.  
Public Methodstatic (Shared in Visual Basic)Overloaded. Clears all pools associated with the connection.  
Public Methodstatic (Shared in Visual Basic)Clears the pool matching ConnectionString of provided OracleConnection object.  
Public MethodCreates a new object that is a copy of the current instance.  
Public MethodOverridden. Closes the connection to the database. This is the preferred method of closing any open connection.  
Public MethodCommits the database transaction.  
Public MethodOverloaded. Creates and returns a OracleCommand object associated with the OracleConnection.  
Public Method (Inherited from System.MarshalByRefObject)
Public Method (Inherited from System.ComponentModel.Component)
Public MethodEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
Public MethodEnlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase)
Public MethodUsed to return the contents of a banner that warns users about potential auditing of their actions.  
Public MethodOverloaded. Gets OracleGlobalization settings for the current database.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodReturns the status of the specified transaction. Requires Oracle 12c and works only in OCI mode.  
Public MethodGets a native handle for the OracleConnection.  
Public MethodOverloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase)
Public Methodstatic (Shared in Visual Basic)Overloaded. Returns an array of available TNS aliases.  
Public MethodOverloaded. Populates an OracleGlobalization object with client side information.  
Public MethodUsed to return the contents of a banner that warns users about unauthorized access to the database.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Opens connection with Proxy Authentication mechanism.  
Public MethodDetermines whether connection to Oracle server is valid.  
Public MethodClears OCI statement cache for the connection.  
Public MethodRolls back a transaction from a pending state.  
Public MethodThis 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 MethodSets Oracle globalization settings for the current connection.  
Public MethodOverloaded. Specifies sharding key values for the connection to a sharded Oracle database.  
Public Method (Inherited from System.ComponentModel.Component)
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Public EventOccurs when Oracle returns an error message.  
Public EventOccurs when Oracle Failover mechanism takes place.  
Public EventOccurs when a HA event happens.  
Public EventOccurs when Oracle returns a warning or informational message.  
Public EventOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
Public EventOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
Public EventOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
Top
See Also