See Also

OracleConnection Class  | Devart.Data.Oracle Namespace  | OracleDataAdapter Class  | OracleCommand Class

See AlsoDevart.Data.OracleSend comments on this topic.

OracleConnection Class Members

Devart.Data.Oracle Namespace : OracleConnection Class

OracleConnection overview

Public Constructors

Public Constructor OracleConnection ConstructorOverloaded. Initializes a new instance of the OracleConnection class.

Public Properties

Public Property AutoCommitDetermines whether modifications will be committed automatically at the server or not.
Public Property ClientIdThis 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 Property ClientVersionReturns version of Oracle client used for this connection.
Public Property ConnectionStringGets or sets the string used to open an Oracle server database.
Public Property ConnectionTimeoutGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
Public Property ConnectModeOpens a session with administrative privileges SYSDBA or SYSOPER.
Public Property Container (Inherited from System.ComponentModel.Component)Gets the IContainer that contains the Component.
Public Property DataSource (Inherited from Devart.Common.DbConnectionBase)Gets or sets name of the server to which to connect.
Public Property DirectIndicates whether Direct mode of communicating with server should be used.
Public Property HomeGets or sets Oracle Home to be used.
Public Propertystatic (Shared in Visual Basic) HomesGets the list of all available Oracle homes.
Public Property InDistributedTransaction (Inherited from Devart.Common.DbConnectionBase)Indicates whether the connection is enlisted in a distributed transaction.
Public Property NameGets or sets name of the component.
Public Property NumberMappingsGets or sets the collection of number mappings used for this connection.
Public Property OwnerGets or sets a form or other container that the OracleConnection instance belongs to.
Public Property PassParametersByNameDetermines whether parameters will be passed by name to the stored procedure calls.
Public Property PasswordGets or sets the user's password to connect.
Public Property PortGets or sets number of a port to communicate with listener on the server.
Public Property ServerGets or sets the name of TNS alias of the Oracle database to which to connect.
Public Property ServerVersionGets a string containing the version of the instance of Oracle to which the client is connected.
Public Property ServiceNameGets or sets an alias to an Oracle database instance (or many instances) to use in the OracleConnection.Direct mode.
Public Property SidGets or sets a unique name for an Oracle database instance.
Public Property Site (Inherited from System.ComponentModel.Component)Gets or sets the ISite of the Component.
Public Property StateGets the current state of the connection.
Public Property TrimFixedCharSpecifies whether to trim trailing spaces when reading data from fixed-length string data types (CHAR, NCHAR).
Public Property UnicodeGets or sets a value indicating whether the UTF16 charset will be used.
Public Property UserIdGets or sets the name of the user to connect.

Public Methods

Public Method BeginOpen (Inherited from Devart.Common.DbConnectionBase)Starts an asynchronous invocation of an Open method.
Public Method BeginTransactionOverloaded. Begins a transaction at the database.
Public Method ChangeDatabase (Inherited from Devart.Common.DbConnectionBase)Changes the current database associated with an open DbConnectionBase.
Public Method ChangePasswordChanges the password for the specified user.
Public Methodstatic (Shared in Visual Basic) ClearAllPoolsClears all pools associated with the connection.
Public Methodstatic (Shared in Visual Basic) ClearPoolClears the pool matching ConnectionString of provided OracleConnection object.
Public Method CloneCreates a new object that is a copy of the current instance.
Public Method CloseOverridden. Closes the connection to the database. This is the preferred method of closing any open connection.
Public Method CommitCommits the database transaction.
Public Method CreateCommandCreates and returns a OracleCommand object associated with the OracleConnection.
Public Method CreateObjRef (Inherited from System.MarshalByRefObject)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Public Method Dispose (Inherited from System.ComponentModel.Component)Releases all resources used by the Component.
Public Method EndOpen (Inherited from Devart.Common.DbConnectionBase)Ends an asynchronous invocation of the Open method.
Public Method EnlistTransaction (Inherited from Devart.Common.DbConnectionBase)Enlists in the specified transaction.
Public Method GetDatabaseInfoOverloaded. Gets OracleGlobalization settings for the current database.
Public Method GetLifetimeService (Inherited from System.MarshalByRefObject)Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Public Method GetNativeHandleGets a native handle for the OracleConnection.
Public Method GetSchema (Inherited from Devart.Common.DbConnectionBase)Overloaded. Provides information about server schema objects.
Public Methodstatic (Shared in Visual Basic) GetServerListOverloaded. Returns an array of available TNS aliases.
Public Method GetSessionInfoOverloaded. Populates an OracleGlobalization object with client side information.
Public Method InitializeLifetimeService (Inherited from System.MarshalByRefObject)Obtains a lifetime service object to control the lifetime policy for this instance.
Public Method OpenOverloaded. Opens connection with Proxy Authentication mechanism.
Public Method PingDetermines whether connection to Oracle server is valid.
Public Method RollbackRolls back a transaction from a pending state.
Public Method SetSessionInfoSets Oracle globalization settings for the current connection.
Public Method ToString (Inherited from System.ComponentModel.Component)Returns a String containing the name of the Component, if any. This method should not be overridden.

Public Events

Public Event Disposed (Inherited from System.ComponentModel.Component)Occurs when the component is disposed by a call to the Dispose method.
Public Event ErrorOccurs when Oracle returns an error message.
Public Event FailoverOccurs when Oracle Failover mechanism takes place.
Public Event InfoMessageOccurs when Oracle returns a warning or informational message.
Public Event StateChange (Inherited from Devart.Common.DbConnectionBase)Occurs when the state of the connection changes.
Public Event TransactionStateChanged (Inherited from Devart.Common.DbConnectionBase)Occurs when the state of the transaction is changed.
Public Event TransactionStateChanging (Inherited from Devart.Common.DbConnectionBase)Occurs when the state of the transaction is changing.

See Also

OracleConnection Class  | Devart.Data.Oracle Namespace  | OracleDataAdapter Class  | OracleCommand Class

 

 


© 2002 - 2013 Devart. All Rights Reserved.