Namespace System.Data.OracleClient

Classes

• OracleClientFactory public sealed class OracleClientFactory : DbProviderFactory

  Provides a factory for creating Oracle-specific data provider objects.

• OracleCommand public sealed class OracleCommand : DbCommand

  Represents a Transact-SQL statement or stored procedure to execute against an Oracle database.

• OracleConnection public sealed class OracleConnection : DbConnection

  Represents a connection to an Oracle database.

• OracleDataAdapter public sealed class OracleDataAdapter : DbDataAdapter

  Represents a DataSet in-memory cache of rows that represent the data that has been retrieved from the data source and maintains changes to these rows, which are used to reconcile the changes with the data source.

• OracleDataReader public sealed class OracleDataReader : DbDataReader

  Provides access to the rows of a data source.

• OracleParameter public sealed class OracleParameter : DbParameter

  Represents a parameter to an OracleCommand.

• OracleParameterCollection public sealed class OracleParameterCollection : DbParameterCollection

  Represents the collection of parameters and their mappings for an OracleCommand.

• OracleTransaction public sealed class OracleTransaction : DbTransaction

  Represents a transaction to be performed at a Oracle data source.

Enums

• OracleType public enum OracleType

  Specifies the Oracle data types of the columns or the return values of stored procedures.

---

Class Details

OracleClientFactory

Inheritance:

• Object
• DbProviderFactory
• OracleClientFactory

OracleCommand

Inheritance:

• Object
• DbCommand
• OracleCommand

Methods

• ExecuteNonQuery() int ExecuteNonQuery()

  Executes a SQL statement against the Connection and returns the number of rows affected.

• ExecuteReader() OracleDataReader ExecuteReader()

  Executes the CommandText and returns an OracleDataReader.

• ExecuteScalar() object ExecuteScalar()

  Executes the query and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

OracleConnection

Inheritance:

• Object
• MarshalByRefObject
• DbConnection
• OracleConnection

Properties

• ConnectionString string ConnectionString { get; set; }

  Gets or sets the connection string used to open the Oracle database.

• State ConnectionState State { get; }

  Gets the current state of the connection.

Methods

• Open() void Open()

  Opens a database connection to the data source specified by the ConnectionString property.

• Close() void Close()

  Closes the connection to the data source.

OracleDataAdapter

Inheritance:

• Object
• MarshalByRefObject
• Component
• DbDataAdapter
• OracleDataAdapter

OracleDataReader

Inheritance:

• Object
• MarshalByRefObject
• DbDataReader
• OracleDataReader

OracleParameter

Inheritance:

• Object
• MarshalByRefObject
• IDbDataParameter
• IDataParameter
• DbParameter
• OracleParameter

OracleParameterCollection

Inheritance:

• Object
• MarshalByRefObject
• IDataParameterCollection
• DbParameterCollection
• OracleParameterCollection

OracleTransaction

Inheritance:

• Object
• MarshalByRefObject
• IDbTransaction
• DbTransaction
• OracleTransaction

OracleType

Inheritance:

• Object
• ValueType
• Enum
• OracleType

Members

• BFile

  Represents an Oracle BFILE data type.

• Blob

  Represents an Oracle BLOB data type.

• Char

  Represents an Oracle CHAR data type.

• Clob

  Represents an Oracle CLOB data type.

• Cursor

  Represents an Oracle REF CURSOR data type.

• Date

  Represents an Oracle DATE data type.

• Float

  Represents an Oracle FLOAT data type.

• Int16

  Represents an Oracle SMALLINT data type.

• Int32

  Represents an Oracle INTEGER data type.

• Int64

  Represents an Oracle NUMBER data type.

• IntervalYearMonth

  Represents an Oracle INTERVAL YEAR TO MONTH data type.

• IntervalDaySecond

  Represents an Oracle INTERVAL DAY TO SECOND data type.

• Long

  Represents an Oracle LONG data type.

• LongRaw

  Represents an Oracle LONG RAW data type.

• NChar

  Represents an Oracle NCHAR data type.

• NClob

  Represents an Oracle NCLOB data type.

• Number

  Represents an Oracle NUMBER data type.

• NVarChar

  Represents an Oracle NVARCHAR2 data type.

• Raw

  Represents an Oracle RAW data type.

• RowId

  Represents an Oracle ROWID data type.

• Timestamp

  Represents an Oracle TIMESTAMP data type.

• TimestampLTZ

  Represents an Oracle TIMESTAMP WITH LOCAL TIME ZONE data type.

• TimestampTZ

  Represents an Oracle TIMESTAMP WITH TIME ZONE data type.

• VArray

  Represents an Oracle VARRAY data type.

• VarChar2

  Represents an Oracle VARCHAR2 data type.