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

In This Topic
    OracleConnection Class Members
    In This Topic

    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 PropertyGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (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 PropertyGets a string containing the version of the instance of Oracle to which the client is connected.  
    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 PropertyGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (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 MethodCreates 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 MethodReleases all resources used by the System.ComponentModel.Component. (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 MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (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 MethodObtains a lifetime service object to control the lifetime policy for this instance. (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 MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
    Top
    Public Events
     NameDescription
    Public EventOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (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