1/158

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Passwords in Code Examples
• Conventions

What's New in Oracle Data Provider for .NET?

• New Features in Oracle Data Provider for .NET Release 11.2.0.3
• New Features in Oracle Data Provider for .NET Release 11.2.0.2
• New Features in Oracle Data Provider for .NET Release 11.2.0.1.2
• New Features in Oracle Data Provider for .NET Release 11.2
• New Features in Oracle Data Provider for .NET Release 11.1.0.7.20
• New Features in Oracle Data Provider for .NET Release 11.1.0.6.20
• New Features in Oracle Data Provider for .NET Release 11.1
• New Features in Oracle Data Provider for .NET Release 10.2.0.4
• New Features in Oracle Data Provider for .NET Release 10.2.0.3
• New Features in Oracle Data Provider for .NET Release 10.2.0.2
• New Features in Oracle Data Provider for .NET Release 10.2
• New Features in Oracle Data Provider for .NET Release 10.1.0.3
• New Features in Oracle Data Provider for .NET Release 10.1
• New Features in Oracle Data Provider for .NET Release 9.2.0.4

1 Introducing Oracle Data Provider for .NET

• .NET Data Access in Oracle: Products and Documentation
  • Oracle Data Provider for .NET (ODP.NET)
  • Oracle Developer Tools for Visual Studio
  • Oracle Database Extensions for .NET
  • Oracle Providers for ASP.NET
  • Oracle Services for Microsoft Transaction Server
  • Oracle TimesTen In-Memory Database
• Overview of Oracle Data Provider for .NET (ODP.NET)
• Oracle Data Provider for .NET Assembly
  • Oracle.DataAccess.Client Namespace
    • Oracle.DataAccess.Client
    • Oracle.DataAccess.Client Enumerations
  • Oracle.DataAccess.Types Namespace
    • Oracle.DataAccess.Types Structures
    • Oracle.DataAccess.Types Exceptions
    • Oracle.DataAccess.Types Classes
    • Oracle.DataAccess.Types Interfaces
    • Oracle.DataAccess.Types Enumerations
• Using ODP.NET Client Provider in a Simple Application

2 Installing and Configuring Oracle Data Provider for .NET

• System Requirements
• Oracle Data Provider for .NET Versioning Scheme
• Installing Oracle Data Provider for .NET
  • File Locations After Installation
  • Search Order for Unmanaged DLLs
    • ODP.NET and Dependent Unmanaged DLL Mismatch
• Configuring Oracle Data Provider for .NET
  • Supported Configuration Settings
  • Windows Registry
  • Configuration File Support
  • Sample Configuration Files
• Configuring a Port to Listen for Database Notifications
• General .NET Programming Recommendations and Tips for ODP.NET

3 Features of Oracle Data Provider for .NET

• Connecting to Oracle Database
  • Connection String Attributes
  • Specifying the Data Source Attribute
    • Using the TNS Alias
    • Using the Connect Descriptor
    • Using Easy Connect Naming Method
  • Connection Pooling
    • Using Connection Pooling
  • Connection Pool Management
  • Connection Pool Performance Counters
    • Publishing Performance Counters
    • Setting Performance Counters Using app.config Entry
    • Instance Names of Performance Counters
  • Edition-Based Redefinition
  • Connecting to an Oracle Real Application Clusters (Oracle RAC) Database
    • Connecting in Oracle Real Application Clusters (Oracle RAC) and Data Guard Database
    • Connection Optimization for Oracle RAC and Oracle Data Guard
    • Pool Size Attributes in an Oracle RAC Database
  • Operating System Authentication
  • Privileged Connections
  • Password Expiration
  • Proxy Authentication
  • Dynamic Distributed Transaction Enlistment
  • Client Identifier and End-to-End Tracing
  • Transparent Application Failover (TAF) Callback Support
    • TAF Notification
    • When Failover Occurs
    • Registering an Event Handler for Failover
• ADO.NET 2.0 Features
  • About ADO.NET 2.0
  • Base Classes and Provider Factory Classes
  • Connection String Builder
  • Data Source Enumerator
  • Support for Code Access Security
    • Configuring OraclePermission
    • Configuring OraclePermission for Web Applications with High or Medium Trust Levels
    • Configuring OraclePermission for Windows Applications Running in a Partial Trust Environment
  • Support for Schema Discovery
    • User Customization of Metadata
  • System.Transactions and Promotable Transactions
    • Implicit Transaction Enlistment Using TransactionScope
    • Explicit Transaction Enlistment Using CommittableTransaction
    • Local Transaction Support for Older Databases
  • Batch Processing Support
  • ADO.NET 2.0 Only Classes and Class Members
  • Bulk Copy Support
    • Data Types Supported by Bulk Copy
    • Restrictions on Oracle Bulk Copy of a Single Partition
    • Integrity Constraints Affecting Oracle Bulk Copy
    • Database Insert Triggers
    • Field Defaults
• ADO.NET Entity Framework and LINQ to Entities
  • Mapping Oracle Data Types to EDM Types
    • EDM Type Facets
  • Oracle Number Default Data Type Mapping and Customization
    • Resolving Compilation Errors When Using Custom Mapping
    • Mapping Boolean and Guid Parameters in Custom INSERT, UPDATE, and DELETE Stored Procedures
• OracleCommand Object
  • Transactions
  • Parameter Binding
    • Data Types BINARY_FLOAT and BINARY_DOUBLE
    • OracleDbType Enumeration Type
    • Inference of DbType, OracleDbType, and .NET Types
    • PL/SQL Associative Array Binding
    • Array Binding
  • Statement Caching
    • Statement Caching Connection String Attributes
    • Enabling Statement Caching through the Registry
    • Statement Caching Methods and Properties
    • Connections and Statement Caching
    • Pooling and Statement Caching
  • Self-Tuning
    • Self-Tuning Statement Caching
    • Enabling or Disabling Self-Tuning for Applications
    • Tracing Optimization Changes
• ODP.NET Types Overview
• Obtaining Data from an OracleDataReader Object
  • Typed OracleDataReader Accessors
    • .NET Type Accessors
    • ODP.NET Type Accessors
  • Obtaining LONG and LONG RAW Data
    • Setting InitialLONGFetchSize to Zero or a Value Greater than Zero
    • Setting InitialLONGFetchSize to -1
  • Obtaining LOB Data
    • Setting InitialLOBFetchSize to Zero
    • Setting InitialLOBFetchSize to a Value Greater than Zero
    • Setting InitialLOBFetchSize to -1
    • Performance Considerations Related to the InitialLOBFetchSize Property
  • Controlling the Number of Rows Fetched in One Database Round-Trip
    • Use of FetchSize
    • Fine-Tuning FetchSize
    • Using the RowSize Property
• PL/SQL REF CURSOR and OracleRefCursor
  • Obtaining an OracleRefCursor Object
  • Obtaining a REF CURSOR Data Type
  • Populating an OracleDataReader from a REF CURSOR
  • Populating the DataSet from a REF CURSOR
  • Populating an OracleRefCursor from a REF CURSOR
  • Updating a DataSet Obtained from a REF CURSOR
  • Behavior of ExecuteScalar Method for REF CURSOR
  • Passing a REF CURSOR to a Stored Procedure
• Implicit REF CURSOR Binding
  • Specifying REF CURSOR Bind and Metadata Information in the .NET Configuration File
  • Sample Configuration File and Application
  • Usage Considerations
    • CommandText Property Considerations
    • Bind Considerations
    • Overloaded Stored Procedures
    • Type Initialization Exceptions
    • Using Stored Functions with Function Import
• LOB Support
  • Large Character and Large Binary Data Types
  • Oracle Data Provider for .NET LOB Objects
  • Updating LOBs Using a DataSet
  • Updating LOBs Using OracleCommand and OracleParameter
  • Updating LOBs Using ODP.NET LOB Objects
  • Temporary LOBs
• ODP.NET XML Support
  • Supported XML Features
  • XQuery Support
  • OracleXmlType and Connection Dependency
  • Updating XMLType Data in the Database
    • Updating with DataSet, OracleDataAdapter, and OracleCommandBuilder
    • Updating with OracleCommand and OracleParameter
  • Updating XML Data in OracleXmlType
  • Characters with Special Meaning in XML
  • Retrieving Query Result Set as XML
    • Handling Date and Time Format
    • Characters with Special Meaning in Column Data
    • Characters in Table or View Name
    • Case-Sensitivity in Column Name to XML Element Name Mapping
    • Column Name to XML Element Name Mapping
    • Object-Relational Data
    • NULL Values
  • Data Manipulation Using XML
    • Handling Date and Time Format
    • Saving Changes Using XML
    • Characters with Special Meaning in Column Data
    • Characters with Special Meaning in Table or View Name
    • Case-Sensitivity in XML Element Name to Column Name Mapping
    • XML Element Name to Column Name Mapping
    • Saving Changes to a Table Using an XML Document
    • Object-Relational Data
    • Multiple Tables
    • Commit Transactions
• Oracle User-Defined Types (UDTs) and .NET Custom Types
  • Oracle User-Defined Types (UDTs)
  • Custom Types
    • Required Custom Type Implementations
    • Optional Custom Type Implementations
  • Specifying Custom Type Mappings
    • Using a Custom Type Factory to Specify Custom Type Mappings
    • Using XML in Configuration Files to Specify Custom Type Mappings
    • Using Custom Type Mappings
  • Converting Between Custom Types and Oracle UDTs
  • Oracle UDT Attribute Mappings
  • Oracle UDT Retrieval from OracleDataReader
  • Oracle UDT Metadata Retrieval from OracleDataReader
  • Oracle UDT Parameter Binding with OracleParameter
    • Guidelines for Binding UDT Input and Output Parameters
    • UDT Input Parameter Binding with OracleParameters
    • UDT Output Parameter Binding with OracleParameters
  • Populating the DataSet with Oracle UDTs
  • UDT Method Invocation
  • Configuration Settings for Oracle UDTs
    • StatementCacheWithUdts
    • UdtCacheSize
• Oracle Streams Advanced Queuing Support
  • Using ODP.NET for Advanced Queuing
    • Enqueuing and Dequeuing Example
• Database Change Notification Support
  • Database Change Notification Classes
  • Supported Operations
  • Requirements of Notification Registration
  • Using Database Change Notification
    • Application Steps
    • Flow of Notification Process
  • Best Practice Guidelines and Performance Considerations
• OracleDataAdapter Safe Type Mapping
  • Comparison Between Oracle Data Types and .NET Types
  • SafeMapping Property
    • Using Safe Type Mapping
• OracleDataAdapter Requery Property
• Guaranteeing Uniqueness in Updating DataSet to Database
  • What Constitutes Uniqueness in DataRow Objects?
  • Configuring PrimaryKey and Constraints Properties
  • Updating Without PrimaryKey and Constraints Configuration
• Globalization Support
  • Globalization Settings
    • Client Globalization Settings
    • Session Globalization Settings
    • Thread-Based Globalization Settings
  • Globalization-Sensitive Operations
    • Operations Dependent on Client Computer's Globalization Settings
    • Operations Dependent on Thread Globalization Settings
    • Operations Sensitive to Session Globalization Parameters
• Debug Tracing

4 Oracle Data Provider for .NETServer-Side Features

• Introducing .NET Stored Procedure Execution Using ODP.NET
• Limitations and Restrictions on ODP.NET Within .NET Stored Procedure
  • Implicit Database Connection
  • Transaction Support
  • Unsupported SQL Commands
  • Oracle User-Defined Type (UDT) Support
• Porting Client Application to .NET Stored Procedure

5 Oracle Data Provider for .NET Classes

• OracleCommand Class
  • OracleCommand Members
  • OracleCommand Constructors
    • OracleCommand()
    • OracleCommand(string)
    • OracleCommand(string, OracleConnection)
  • OracleCommand Static Methods
  • OracleCommand Properties
    • AddRowid
    • AddToStatementCache
    • ArrayBindCount
    • BindByName
    • CommandText
    • CommandTimeout
    • CommandType
    • Connection
    • DesignTimeVisible
    • FetchSize
    • InitialLOBFetchSize
    • InitialLONGFetchSize
    • Notification
    • NotificationAutoEnlist
    • Parameters
    • RowSize
    • Transaction
    • UpdatedRowSource
    • XmlCommandType
    • XmlQueryProperties
    • XmlSaveProperties
  • OracleCommand Public Methods
    • Cancel
    • Clone
    • CreateParameter
    • ExecuteNonQuery
    • ExecuteReader
    • ExecuteReader()
    • ExecuteReader(CommandBehavior)
    • ExecuteScalar
    • ExecuteStream
    • ExecuteToStream
    • ExecuteXmlReader
• OracleCommandBuilder Class
  • OracleCommandBuilder Members
  • OracleCommandBuilder Constructors
    • OracleCommandBuilder()
    • OracleCommandBuilder(OracleDataAdapter)
  • OracleCommandBuilder Static Methods
    • DeriveParameters
  • OracleCommandBuilder Properties
    • CaseSensitive
    • CatalogLocation
    • CatalogSeparator
    • ConflictOption
    • DataAdapter
    • QuotePrefix
    • QuoteSuffix
    • SchemaSeparator
  • OracleCommandBuilder Public Methods
    • GetDeleteCommand
    • GetInsertCommand
    • GetUpdateCommand
    • QuoteIdentifier
    • RefreshSchema
    • UnquoteIdentifier
  • OracleCommandBuilder Events
• OracleConnection Class
  • OracleConnection Members
  • OracleConnection Constructors
    • OracleConnection()
    • OracleConnection(String)
  • OracleConnection Static Properties
    • IsAvailable
  • OracleConnection Static Methods
    • ClearPool
    • ClearAllPools
  • OracleConnection Properties
    • ActionName
    • ClientId
    • ClientInfo
    • ConnectionString
    • ConnectionTimeout
    • ConnectionType
    • Database
    • DatabaseDomainName
    • DatabaseName
    • DataSource
    • HostName
    • InstanceName
    • ModuleName
    • ServerVersion
    • ServiceName
    • State
    • StatementCacheSize
  • OracleConnection Public Methods
    • BeginTransaction
    • BeginTransaction()
    • BeginTransaction(IsolationLevel)
    • ChangeDatabase
    • Clone
    • Close
    • CreateCommand
    • EnlistDistributedTransaction
    • EnlistTransaction
    • FlushCache
    • GetSchema
    • GetSchema()
    • GetSchema (string collectionName)
    • GetSchema (string collectionName, string[] restrictions)
    • GetSessionInfo
    • GetSessionInfo()
    • GetSessionInfo(OracleGlobalization)
    • Open
    • OpenWithNewPassword
    • PurgeStatementCache
    • SetSessionInfo
  • OracleConnection Events
    • Failover
    • HAEvent
    • InfoMessage
    • StateChange
• OracleDataAdapter Class
  • OracleDataAdapter Members
  • OracleDataAdapter Constructors
    • OracleDataAdapter()
    • OracleDataAdapter(OracleCommand)
    • OracleDataAdapter(string, OracleConnection)
    • OracleDataAdapter(string, string)
  • OracleDataAdapter Static Methods
  • OracleDataAdapter Properties
    • DeleteCommand
    • InsertCommand
    • Requery
    • ReturnProviderSpecificTypes
    • SafeMapping
    • SelectCommand
    • UpdateBatchSize
    • UpdateCommand
  • OracleDataAdapter Public Methods
    • Fill
    • Fill(DataTable, OracleRefCursor)
    • Fill(DataSet, OracleRefCursor)
    • Fill(DataSet, string, OracleRefCursor)
    • Fill(DataSet, int, int, string, OracleRefCursor)
  • OracleDataAdapter Events
    • RowUpdated
    • RowUpdating
• OracleDatabase Class
  • OracleDatabase Members
  • OracleDatabase Constructor
  • OracleDatabase Properties
    • ServerVersion
  • OracleDatabase Public Methods
    • ExecuteNonQuery
    • Shutdown
    • Shutdown()
    • Shutdown(OracleDBShutdownMode, bool)
    • Startup
    • Startup()
    • Startup(OracleDBStartupMode, string, bool)
• OracleDataReader Class
  • OracleDataReader Members
  • OracleDataReader Static Methods
  • OracleDataReader Properties
    • Depth
    • FetchSize
    • FieldCount
    • HasRows
    • HiddenFieldCount
    • IsClosed
    • Item
    • Item [index]
    • Item [string]
    • InitialLOBFetchSize
    • InitialLONGFetchSize
    • RecordsAffected
    • RowSize
    • VisibleFieldCount
  • OracleDataReader Public Methods
    • Close
    • Dispose
    • GetBoolean
    • GetByte
    • GetBytes
    • GetChar
    • GetChars
    • GetDataTypeName
    • GetDateTime
    • GetDecimal
    • GetDouble
    • GetEnumerator
    • GetFieldType
    • GetFloat
    • GetGuid
    • GetInt16
    • GetInt32
    • GetInt64
    • GetName
    • GetOracleBFile
    • GetOracleBinary
    • GetOracleBlob
    • GetOracleBlobForUpdate
    • GetOracleBlobForUpdate(int)
    • GetOracleBlobForUpdate(int, int)
    • GetOracleClob
    • GetOracleClobForUpdate
    • GetOracleClobForUpdate(int)
    • GetOracleClobForUpdate(int, int)
    • GetOracleDate
    • GetOracleDecimal
    • GetOracleIntervalDS
    • GetOracleIntervalYM
    • GetOracleRef
    • GetOracleString
    • GetOracleTimeStamp
    • GetOracleTimeStampLTZ
    • GetOracleTimeStampTZ
    • GetOracleXmlType
    • GetOracleValue
    • GetOracleValues
    • GetOrdinal
    • GetProviderSpecificFieldType
    • GetProviderSpecificValue
    • GetProviderSpecificValues
    • GetSchemaTable
    • GetString
    • GetTimeSpan
    • GetValue
    • GetValues
    • GetXmlReader
    • IsDBNull
    • NextResult
    • Read
• OracleError Class
  • OracleError Members
  • OracleError Static Methods
  • OracleError Properties
    • ArrayBindIndex
    • DataSource
    • Message
    • Number
    • Procedure
    • Source
  • OracleError Methods
    • ToString
• OracleErrorCollection Class
  • OracleErrorCollection Members
  • OracleErrorCollection Static Methods
  • OracleErrorCollection Properties
  • OracleErrorCollection Public Methods
• OracleException Class
  • OracleException Members
  • OracleException Static Methods
  • OracleException Properties
    • DataSource
    • Errors
    • Message
    • Number
    • Procedure
    • Source
  • OracleException Methods
    • GetObjectData
    • ToString
• OracleInfoMessageEventArgs Class
  • OracleInfoMessageEventArgs Members
  • OracleInfoMessageEventArgs Static Methods
  • OracleInfoMessageEventArgs Properties
    • Errors
    • Message
    • Source
  • OracleInfoMessageEventArgs Public Methods
• OracleInfoMessageEventHandler Delegate
• OracleParameter Class
  • OracleParameter Members
  • OracleParameter Constructors
    • OracleParameter()
    • OracleParameter (string, OracleDbType)
    • OracleParameter(string, object)
    • OracleParameter(string, OracleDbType, ParameterDirection)
    • OracleParameter(string, OracleDbType, object, ParameterDirection)
    • OracleParameter(string, OracleDbType, int)
    • OracleParameter(string, OracleDbType, int, string)
    • OracleParameter(string, OracleDbType, int, ParameterDirection, bool, byte, byte, string, DataRowVersion, object)
    • OracleParameter(string, OracleDbType, int, object, ParameterDirection)
  • OracleParameter Static Methods
  • OracleParameter Properties
    • ArrayBindSize
    • ArrayBindStatus
    • CollectionType
    • DbType
    • Direction
    • IsNullable
    • Offset
    • OracleDbType
    • OracleDbTypeEx
    • ParameterName
    • Precision
    • Scale
    • Size
    • SourceColumn
    • SourceColumnNullMapping
    • SourceVersion
    • Status
    • UdtTypeName
    • Value
  • OracleParameter Public Methods
    • Clone
    • Dispose
    • ResetDbType
    • ResetOracleDbType
• OracleParameterCollection Class
  • OracleParameterCollection Members
  • OracleParameterCollection Static Methods
  • OracleParameterCollection Properties
    • Count
    • Item
    • Item[int]
    • Item[string]
  • OracleParameterCollection Public Methods
    • Add
    • Add(object)
    • Add(OracleParameter)
    • Add(string, object)
    • Add(string, OracleDbType)
    • Add(string, OracleDbType, ParameterDirection)
    • Add(string, OracleDbType, object, ParameterDirection)
    • Add(string, OracleDbType, int, object, ParameterDirection)
    • Add(string, OracleDbType, int)
    • Add (string, OracleDbType, int, string)
    • Add(string, OracleDbType, int, ParameterDirection, bool, byte, byte, string, DataRowVersion, object)
    • AddRange
    • Clear
    • Contains
    • Contains(object)
    • Contains(string)
    • CopyTo
    • IndexOf
    • IndexOf(object)
    • IndexOf(String)
    • Insert
    • Remove
    • RemoveAt
    • RemoveAt(int)
    • RemoveAt(String)
• OraclePermission Class
  • OraclePermission Members
  • OraclePermission Constructor
  • OraclePermission Static Methods
  • OraclePermission Public Properties
  • OraclePermission Public Methods
    • Add
    • Copy
    • IsSubsetOf
• OraclePermissionAttribute Class
  • OraclePermissionAttribute Members
  • OraclePermissionAttribute Constructor
  • OraclePermissionAttribute Static Methods
  • OraclePermissionAttribute Public Properties
  • OraclePermissionAttribute Public Methods
    • CreatePermission
• OracleRowUpdatedEventArgs Class
  • OracleRowUpdatedEventArgs Members
  • OracleRowUpdatedEventArgs Constructor
  • OracleRowUpdatedEventArgs Static Methods
  • OracleRowUpdatedEventArgs Properties
    • Command
  • OracleRowUpdatedEventArgs Public Methods
• OracleRowUpdatedEventHandler Delegate
• OracleRowUpdatingEventArgs Class
  • OracleRowUpdatingEventArgs Members
  • OracleRowUpdatingEventArgs Constructor
  • OracleRowUpdatingEventArgs Static Methods
  • OracleRowUpdatingEventArgs Properties
    • Command
  • OracleRowUpdatingEventArgs Public Methods
• OracleRowUpdatingEventHandler Delegate
• OracleTransaction Class
  • OracleTransaction Members
  • OracleTransaction Static Methods
  • OracleTransaction Properties
    • IsolationLevel
    • Connection
  • OracleTransaction Public Methods
    • Commit
    • Dispose
    • Rollback
    • Rollback()
    • Rollback(string)
    • Save
• OracleConnectionType Enumeration
• OracleCollectionType Enumeration
• OracleDBShutdownMode Enumeration
• OracleDBStartupMode Enumeration
• OracleDbType Enumeration
• OracleParameterStatus Enumeration

6 Oracle Data Provider for .NET XML-Related Classes

• OracleXmlCommandType Enumeration
• OracleXmlQueryProperties Class
  • OracleXmlQueryProperties Members
  • OracleXmlQueryProperties Constructor
  • OracleXmlQueryProperties Properties
    • MaxRows
    • RootTag
    • RowTag
    • Xslt
    • XsltParams
  • OracleXmlQueryProperties Public Methods
    • Clone
• OracleXmlSaveProperties Class
  • OracleXmlSaveProperties Members
  • OracleXmlSaveProperties Constructor
  • OracleXmlSaveProperties Properties
    • KeyColumnsList
    • RowTag
    • Table
    • UpdateColumnsList
    • Xslt
    • XsltParams
  • OracleXmlSaveProperties Public Methods
    • Clone
• OracleXmlStream Class
  • OracleXmlStream Members
  • OracleXmlStream Constructor
  • OracleXmlStream Static Methods
  • OracleXmlStream Instance Properties
    • CanRead
    • CanSeek
    • Connection
    • Length
    • Position
    • Value
  • OracleXmlStream Instance Methods
    • Clone
    • Close
    • Dispose
    • Read
    • Read(byte[ ], int, int)
    • Read(char[ ], int, int)
    • Seek
• OracleXmlType Class
  • OracleXmlType Members
  • OracleXmlType Constructors
    • OracleXmlType(OracleClob)
    • OracleXmlType(OracleConnection, string)
    • OracleXmlType(OracleConnection, XmlReader)
    • OracleXmlType(OracleConnection, XmlDocument)
  • OracleXmlType Static Methods
  • OracleXmlType Instance Properties
    • Connection
    • IsEmpty
    • IsFragment
    • IsSchemaBased
    • RootElement
    • Schema
    • SchemaUrl
    • Value
  • OracleXmlType Instance Methods
    • Clone
    • Dispose
    • Extract
    • Extract(string, string)
    • Extract(string, XmlNameSpaceManager)
    • GetStream
    • GetXmlDocument
    • GetXmlReader
    • IsExists
    • IsExists(string, string)
    • IsExists(string, XmlNameSpaceManager)
    • Transform
    • Transform(OracleXmlType, string)
    • Transform(string, string)
    • Update
    • Update(string, string, string)
    • Update(string, XmlNameSpaceManager, string)
    • Update(string, string, OracleXmlType)
    • Update(string, XmlNameSpaceManager, OracleXmlType)
    • Validate

7 ADO.NET 2.0 Classes

• OracleClientFactory Class
  • OracleClientFactory Members
  • OracleClientFactory Public Properties
    • CanCreateDataSourceEnumerator
  • OracleClientFactory Public Methods
    • CreateCommand
    • CreateCommandBuilder
    • CreateConnection
    • CreateConnectionStringBuilder
    • CreateDataAdapter
    • CreateDataSourceEnumerator
    • CreateParameter
    • CreatePermission
• OracleConnectionStringBuilder Class
  • OracleConnectionStringBuilder Members
  • OracleConnectionStringBuilder Constructors
    • OracleConnectionStringBuilder()
    • OracleConnectionStringBuilder(string)
  • OracleConnectionStringBuilder Public Properties
    • ConnectionLifetime
    • ConnectionTimeout
    • ContextConnection
    • DataSource
    • DBAPrivilege
    • DecrPoolSize
    • Enlist
    • HAEvents
    • IncrPoolSize
    • IsFixedSize
    • Item
    • Keys
    • LoadBalancing
    • MaxPoolSize
    • MetadataPooling
    • MinPoolSize
    • Password
    • PersistSecurityInfo
    • Pooling
    • ProxyPassword
    • ProxyUserId
    • SelfTuning
    • StatementCachePurge
    • StatementCacheSize
    • UserID
    • ValidateConnection
    • Values
  • OracleConnectionStringBuilder Public Methods
    • Clear
    • ContainsKey
    • Remove
    • TryGetValue
• OracleDataSourceEnumerator Class
  • OracleDataSourceEnumerator Members
  • OracleDataSourceEnumerator Public Methods
    • GetDataSources

8 Oracle Data Provider for .NET HA Event Classes

• OracleHAEventArgs Class
  • OracleHAEventArgs Members
  • OracleHAEventArgs Properties
    • DatabaseDomainName
    • DatabaseName
    • HostName
    • InstanceName
    • ServiceName
    • Source
    • Status
    • Time
• OracleHAEventHandler Delegate
• OracleHAEventSource Enumeration
• OracleHAEventStatus Enumeration

9 Database Change Notification

• OracleDependency Class
  • OracleDependency Members
  • OracleDependency Constructors
    • OracleDependency ( )
    • OracleDependency(OracleCommand)
    • OracleDependency(OracleCommand, bool, int, bool)
  • OracleDependency Static Fields
    • Port
  • OracleDependency Static Methods
    • GetOracleDependency
  • OracleDependency Properties
    • DataSource
    • HasChanges
    • Id
    • IsEnabled
    • QueryBasedNotification
    • RegisteredQueryIDs
    • RegisteredResources
    • RowidInfo
    • UserName
  • OracleDependency Methods
    • AddCommandDependency
    • RemoveRegistration
  • OracleDependency Events
    • OnChange
• OracleNotificationRequest Class
  • OracleNotificationRequest Members
  • OracleNotificationRequest Static Methods
  • OracleNotificationRequest Properties
    • IsNotifiedOnce
    • IsPersistent
    • Timeout
    • GroupingNotificationEnabled
    • GroupingType
    • GroupingInterval
  • OracleNotificationRequest Methods
• OracleNotificationEventArgs Class
  • OracleNotificationEventArgs Members
  • OracleNotificationEventArgs Static Fields
  • OracleNotificationEventArgs Static Methods
  • OracleNotificationEventArgs Properties
    • Details
    • Info
    • ResourceNames
    • Source
    • Type
  • OracleNotificationEventArgs Methods
• OnChangeEventHandler Delegate
• OracleRowidInfo Enumeration
• OracleNotificationType Enumeration
• OracleNotificationSource Enumeration
• OracleNotificationInfo Enumeration

10 Oracle Data Provider for .NET Globalization Classes

• OracleGlobalization Class
  • OracleGlobalization Members
  • OracleGlobalization Static Methods
    • GetClientInfo
    • GetClientInfo()
    • GetClientInfo(OracleGlobalization)
    • GetThreadInfo
    • GetThreadInfo()
    • GetThreadInfo(OracleGlobalization)
    • SetThreadInfo
  • OracleGlobalization Properties
    • Calendar
    • ClientCharacterSet
    • Comparison
    • Currency
    • DateFormat
    • DateLanguage
    • DualCurrency
    • ISOCurrency
    • Language
    • LengthSemantics
    • NCharConversionException
    • NumericCharacters
    • Sort
    • Territory
    • TimeStampFormat
    • TimeStampTZFormat
    • TimeZone
  • OracleGlobalization Public Methods
    • Clone

11 Oracle Data Provider for .NET Failover Classes

• OracleFailoverEventArgs Class
  • OracleFailoverEventArgs Members
  • OracleFailoverEventArgs Static Methods
  • OracleFailoverEventArgs Properties
    • FailoverType
    • FailoverEvent
  • OracleFailoverEventArgs Public Methods
• OracleFailoverEventHandler Delegate
• FailoverEvent Enumeration
• FailoverReturnCode Enumeration
• FailoverType Enumeration

12 Advanced Queuing Support

• OracleAQAgent Class
  • OracleAQAgent Members
  • OracleAQAgent Constructors
    • OracleAQAgent (string)
    • OracleAQAgent (string, string)
  • OracleAQAgent Properties
    • Address
    • Name
• OracleAQDequeueOptions Class
  • OracleAQDequeueOptions Members
  • OracleAQDequeueOptions Constructor
  • OracleAQDequeueOptions Properties
    • ConsumerName
    • Correlation
    • DeliveryMode
    • DequeueMode
    • MessageId
    • NavigationMode
    • ProviderSpecificType
    • Visibility
    • Wait
  • OracleAQDequeueOptions Public Methods
    • Clone
• OracleAQEnqueueOptions Class
  • OracleAQEnqueueOptions Members
  • OracleAQEnqueueOptions Constructor
  • OracleAQEnqueueOptions Properties
    • DeliveryMode
    • Visibility
  • OracleAQEnqueueOptions Public Methods
    • Clone
• OracleAQMessage Class
  • OracleAQMessage Members
  • OracleAQMessage Constructors
    • OracleAQMessage()
    • OracleAQMessage(Object)
  • OracleAQMessage Properties
    • Correlation
    • Delay
    • DeliveryMode
    • DequeueAttempts
    • EnqueueTime
    • ExceptionQueue
    • Expiration
    • MessageId
    • OriginalMessageId
    • Payload
    • Priority
    • Recipients
    • SenderId
    • State
    • TransactionGroup
• OracleAQMessageAvailableEventArgs Class
  • OracleAQMessageAvailableEventArgs Members
  • OracleAQMessageAvailableEventArgs Properties
    • AvailableMessages
    • ConsumerName
    • Correlation
    • Delay
    • DeliveryMode
    • EnqueueTime
    • ExceptionQueue
    • Expiration
    • MessageId
    • NotificationType
    • OriginalMessageId
    • Priority
    • QueueName
    • SenderId
    • State
• OracleAQMessageAvailableEventHandler Delegate
• OracleAQQueue Class
  • OracleAQQueue Members
  • OracleAQQueue Constructors
    • OracleAQQueue(string)
    • OracleAQQueue(string, OracleConnection)
    • OracleAQQueue(string, OracleConnection, OracleAQMessageType)
    • OracleAQQueue(string, OracleConnection, OracleAQMessageType, string)
  • OracleAQQueue Static Methods
    • Listen
    • Listen(OracleConnection, OracleAQAgent[ ])
    • Listen(OracleConnection, OracleAQAgent[ ], int)
  • OracleAQQueue Properties
    • Connection
    • DequeueOptions
    • EnqueueOptions
    • MessageType
    • Name
    • Notification
    • NotificationConsumers
    • UdtTypeName
  • OracleAQQueue Public Methods
    • Dequeue
    • Dequeue()
    • Dequeue(OracleAQDequeueOptions)
    • DequeueArray
    • DequeueArray(int)
    • DequeueArray(int, OracleAQDequeueOptions)
    • Dispose
    • Enqueue
    • Enqueue(OracleAQMessage)
    • Enqueue(OracleAQMessage, OracleAQEnqueueOptions)
    • EnqueueArray
    • EnqueueArray(OracleAQMessage[ ])
    • EnqueueArray(OracleAQMessage[ ], OracleAQEnqueueOptions)
    • Listen
    • Listen(string[])
    • Listen (string[], int)
  • OracleAQQueue Events
    • MessageAvailable Event
• OracleAQDequeueMode Enumeration
• OracleAQMessageDeliveryMode Enumeration
• OracleAQMessageState Enumeration
• OracleAQMessageType Enumeration
• OracleAQNavigationMode Enumeration
• OracleAQNotificationGroupingType Enumeration
• OracleAQNotificationType Enumeration
• OracleAQVisibilityMode Enumeration

13 Oracle Data Provider for .NET Types Classes

• OracleBFile Class
  • OracleBFile Members
  • OracleBFile Constructors
    • OracleBFile(OracleConnection)
    • OracleBFile(OracleConnection, string, string)
  • OracleBFile Static Fields
    • MaxSize
    • Null
  • OracleBFile Static Methods
  • OracleBFile Instance Properties
    • CanRead
    • CanSeek
    • CanWrite
    • Connection
    • DirectoryName
    • FileExists
    • FileName
    • IsEmpty
    • IsNull
    • IsOpen
    • Length
    • Position
    • Value
  • OracleBFile Instance Methods
    • Clone
    • Close
    • CloseFile
    • Compare
    • CopyTo
    • CopyTo(OracleBlob)
    • CopyTo(OracleBlob, Int64)
    • CopyTo(Int64, OracleBlob, Int64, Int64)
    • CopyTo(OracleClob)
    • CopyTo(OracleClob, Int64)
    • CopyTo(Int64, OracleClob, Int64, Int64)
    • Dispose
    • IsEqual
    • OpenFile
    • Read
    • Search
    • Seek
• OracleBlob Class
  • OracleBlob Members
  • OracleBlob Constructors
    • OracleBlob(OracleConnection)
    • OracleBlob(OracleConnection, bool)
  • OracleBlob Static Fields
    • MaxSize
    • Null
  • OracleBlob Static Methods
  • OracleBlob Instance Properties
    • CanRead
    • CanSeek
    • CanWrite
    • Connection
    • IsEmpty
    • IsInChunkWriteMode
    • IsNull
    • IsTemporary
    • Length
    • OptimumChunkSize
    • Position
    • Value
  • OracleBlob Instance Methods
    • Append
    • Append(OracleBlob)
    • Append(byte[ ], int, int)
    • BeginChunkWrite
    • Clone
    • Close
    • Compare
    • CopyTo
    • CopyTo(OracleBlob)
    • CopyTo(OracleBlob, Int64)
    • CopyTo(Int64, OracleBlob, Int64, Int64)
    • Dispose
    • EndChunkWrite
    • Erase
    • Erase()
    • Erase(Int64, Int64)
    • IsEqual
    • Read
    • Search
    • Seek
    • SetLength
    • Write
• OracleClob Class
  • OracleClob Members
  • OracleClob Constructors
    • OracleClob(OracleConnection)
    • OracleClob(OracleConnection, bool, bool)
  • OracleClob Static Fields
    • MaxSize
    • Null
  • OracleClob Static Methods
  • OracleClob Instance Properties
    • CanRead
    • CanSeek
    • CanWrite
    • Connection
    • IsEmpty
    • IsInChunkWriteMode
    • IsNCLOB
    • IsNull
    • IsTemporary
    • Length
    • OptimumChunkSize
    • Position
    • Value
  • OracleClob Instance Methods
    • Append
    • Append(OracleClob)
    • Append(byte [ ], int, int)
    • Append(char [ ], int, int)
    • BeginChunkWrite
    • Clone
    • Close
    • Compare
    • CopyTo
    • CopyTo(OracleClob)
    • CopyTo(OracleClob, Int64)
    • CopyTo(Int64, OracleClob, Int64, Int64)
    • Dispose
    • EndChunkWrite
    • Erase
    • Erase()
    • Erase(Int64, Int64)
    • GetHashCode
    • IsEqual
    • Read
    • Read(byte [ ], int, int)
    • Read(char [ ], int, int)
    • Search
    • Search(byte[ ], Int64, Int64)
    • Search(char[ ], Int64, Int64)
    • Seek
    • SetLength
    • Write
    • Write(byte[ ], int, int)
    • Write(char[ ], int, int)
• OracleRefCursor Class
  • OracleRefCursor Members
  • OracleRefCursor Static Methods
  • OracleRefCursor Properties
    • Connection
    • FetchSize
    • RowSize
  • OracleRefCursor Instance Methods
    • Dispose
    • GetDataReader

14 Oracle Data Provider for .NET Types Structures

• OracleBinary Structure
  • OracleBinary Members
  • OracleBinary Constructor
  • OracleBinary Static Fields
    • Null
  • OracleBinary Static Methods
    • Concat
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
  • OracleBinary Static Operators
    • operator +
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
  • OracleBinary Static Type Conversion Operators
    • explicit operator byte[ ]
    • implicit operator OracleBinary
  • OracleBinary Properties
    • IsNull
    • Item
    • Length
    • Value
  • OracleBinary Instance Methods
    • CompareTo
    • Equals
    • GetHashCode
    • ToString
• OracleDate Structure
  • OracleDate Members
  • OracleDate Constructors
    • OracleDate(DateTime)
    • OracleDate(string)
    • OracleDate(int, int, int)
    • OracleDate(int, int, int, int, int, int)
    • OracleDate(byte [ ])
  • OracleDate Static Fields
    • MaxValue
    • MinValue
    • Null
  • OracleDate Static Methods
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • GetSysDate
    • Parse
  • OracleDate Static Operators
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
  • OracleDate Static Type Conversions
    • explicit operator DateTime
    • explicit operator OracleDate
    • explicit operator OracleDate(DateTime)
    • explicit operator OracleDate(OracleTimeStamp)
    • explicit operator OracleDate(string)
  • OracleDate Properties
    • BinData
    • Day
    • IsNull
    • Hour
    • Minute
    • Month
    • Second
    • Value
    • Year
  • OracleDate Methods
    • CompareTo
    • Equals
    • GetHashCode
    • GetDaysBetween
    • ToOracleTimeStamp
    • ToString
• OracleDecimal Structure
  • OracleDecimal Members
  • OracleDecimal Constructors
    • OracleDecimal(byte [ ])
    • OracleDecimal(decimal)
    • OracleDecimal(double)
    • OracleDecimal(int)
    • OracleDecimal(float)
    • OracleDecimal(long)
    • OracleDecimal(string)
    • OracleDecimal(string, string)
  • OracleDecimal Static Fields
    • MaxPrecision
    • MaxScale
    • MaxValue
    • MinScale
    • MinValue
    • NegativeOne
    • Null
    • One
    • Pi
    • Zero
  • OracleDecimal Static (Comparison) Methods
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
  • OracleDecimal Static (Manipulation) Methods
    • Abs
    • Add
    • AdjustScale
    • Ceiling
    • ConvertToPrecScale
    • Divide
    • Floor
    • Max
    • Min
    • Mod
    • Multiply
    • Negate
    • Parse
    • Round
    • SetPrecision
    • Shift
    • Sign
    • Sqrt
    • Subtract
    • Truncate
  • OracleDecimal Static (Logarithmic) Methods
    • Exp
    • Log
    • Log(OracleDecimal)
    • Log(OracleDecimal, int)
    • Log(OracleDecimal, OracleDecimal)
    • Pow
    • Pow(OracleDecimal, int)
    • Pow(OracleDecimal, OracleDecimal)
  • OracleDecimal Static (Trigonometric) Methods
    • Acos
    • Asin
    • Atan
    • Atan2
    • Cos
    • Sin
    • Tan
    • Cosh
    • Sinh
    • Tanh
  • OracleDecimal Static (Comparison) Operators
    • operator +
    • operator /
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator *
    • operator -
    • operator -
    • operator%
  • OracleDecimal Static Operators (Conversion from .NET Type to OracleDecimal)
    • implicit operator OracleDecimal
    • implicit operator OracleDecimal(decimal)
    • implicit operator OracleDecimal(int)
    • implicit operator OracleDecimal(long)
    • explicit operator OracleDecimal
    • explicit operator OracleDecimal(double)
    • explicit operator OracleDecimal(string)
  • OracleDecimal Static Operators (Conversion from OracleDecimal to .NET)
    • explicit operator byte
    • explicit operator decimal
    • explicit operator double
    • explicit operator short
    • explicit operator int
    • explicit operator long
    • explicit operator float
  • OracleDecimal Properties
    • BinData
    • Format
    • IsInt
    • IsNull
    • IsPositive
    • IsZero
    • Value
  • OracleDecimal Instance Methods
    • CompareTo
    • Equals
    • GetHashCode
    • ToByte
    • ToDouble
    • ToInt16
    • ToInt32
    • ToInt64
    • ToSingle
    • ToString
• OracleIntervalDS Structure
  • OracleIntervalDS Members
  • OracleIntervalDS Constructors
    • OracleIntervalDS(TimeSpan)
    • OracleIntervalDS(string)
    • OracleIntervalDS(double)
    • OracleIntervalDS(int, int, int, int, double)
    • OracleIntervalDS(int, int, int, int, int)
    • OracleIntervalDS(byte[ ])
  • OracleIntervalDS Static Fields
    • MaxValue
    • MinValue
    • Null
    • Zero
  • OracleIntervalDS Static Methods
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • Parse
    • SetPrecision
  • OracleIntervalDS Static Operators
    • operator +
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator -
    • operator -
    • operator *
    • operator /
  • OracleIntervalDS Type Conversions
    • explicit operator TimeSpan
    • explicit operator OracleIntervalDS
    • implicit operator OracleIntervalDS
  • OracleIntervalDS Properties
    • BinData
    • Days
    • Hours
    • IsNull
    • Milliseconds
    • Minutes
    • Nanoseconds
    • Seconds
    • TotalDays
    • Value
  • OracleIntervalDS Methods
    • CompareTo
    • Equals
    • GetHashCode
    • ToString
• OracleIntervalYM Structure
  • OracleIntervalYM Members
  • OracleIntervalYM Constructors
    • OracleIntervalYM(long)
    • OracleIntervalYM(string)
    • OracleIntervalYM(double)
    • OracleIntervalYM(int, int)
    • OracleIntervalYM(byte[ ])
  • OracleIntervalYM Static Fields
    • MaxValue
    • MinValue
    • Null
    • Zero
  • OracleIntervalYM Static Methods
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • Parse
    • SetPrecision
  • OracleIntervalYM Static Operators
    • operator +
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator -
    • operator -
    • operator *
    • operator /
  • OracleIntervalYM Type Conversions
    • explicit operator long
    • explicit operator OracleIntervalYM
    • implicit operator OracleIntervalYM
  • OracleIntervalYM Properties
    • BinData
    • IsNull
    • Months
    • TotalYears
    • Value
    • Years
  • OracleIntervalYM Methods
    • CompareTo
    • Equals
    • GetHashCode
    • ToString
• OracleString Structure
  • OracleString Members
  • OracleString Constructors
    • OracleString(string)
    • OracleString(string, bool)
    • OracleString(byte [ ], bool)
    • OracleString(byte [ ], bool, bool)
    • OracleString(byte [ ], int, int, bool)
    • OracleString(byte [ ], int, int, bool, bool)
  • OracleString Static Fields
    • Null
  • OracleString Static Methods
    • Concat
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
  • OracleString Static Operators
    • operator +
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
  • OracleString Type Conversions
    • explicit operator string
    • implicit operator OracleString
  • OracleString Properties
    • IsCaseIgnored
    • IsNull
    • Item
    • Length
  • OracleString Methods
    • Clone
    • CompareTo
    • Equals
    • GetHashCode
    • GetNonUnicodeBytes
    • GetUnicodeBytes
    • ToString
• OracleTimeStamp Structure
  • OracleTimeStamp Members
  • OracleTimeStamp Constructors
    • OracleTimeStamp(DateTime)
    • OracleTimeStamp(string)
    • OracleTimeStamp(int, int, int)
    • OracleTimeStamp(int, int, int, int, int, int)
    • OracleTimeStamp(int, int, int, int, int, int, double)
    • OracleTimeStamp(int, int, int, int, int, int, int)
    • OracleTimeStamp(byte [ ])
  • OracleTimeStamp Static Fields
    • MaxValue
    • MinValue
    • Null
  • OracleTimeStamp Static Methods
    • Equals
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • GetSysDate
    • Parse
    • SetPrecision
  • OracleTimeStamp Static Operators
    • operator +
    • operator + (OracleTimeStamp, OracleIntervalDS)
    • operator + (OracleTimeStamp, OracleIntervalYM)
    • operator + (OracleTimeStamp, TimeSpan)
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator -
    • operator - (OracleTimeStamp, OracleIntervalDS)
    • operator - (OracleTimeStamp, OracleIntervalYM)
    • operator - (OracleTimeStamp, TimeSpan)
  • OracleTimeStamp Static Type Conversions
    • explicit operator OracleTimeStamp
    • explicit operator OracleTimeStamp(OracleTimeStampLTZ)
    • explicit operator OracleTimeStamp(OracleTimeStampTZ)
    • explicit operator OracleTimeStamp(string)
    • implicit operator OracleTimeStamp
    • implicit operator OracleTimeStamp(OracleDate)
    • implicit operator OracleTimeStamp(DateTime)
    • explicit operator DateTime
  • OracleTimeStamp Properties
    • BinData
    • Day
    • IsNull
    • Hour
    • Millisecond
    • Minute
    • Month
    • Nanosecond
    • Second
    • Value
    • Year
  • OracleTimeStamp Methods
    • AddDays
    • AddHours
    • AddMilliseconds
    • AddMinutes
    • AddMonths
    • AddNanoseconds
    • AddSeconds
    • AddYears
    • CompareTo
    • Equals
    • GetHashCode
    • GetDaysBetween
    • GetYearsBetween
    • ToOracleDate
    • ToOracleTimeStampLTZ
    • ToOracleTimeStampTZ
    • ToString
• OracleTimeStampLTZ Structure
  • OracleTimeStampLTZ Members
  • OracleTimeStampLTZ Constructors
    • OracleTimeStampLTZ(DateTime)
    • OracleTimeStampLTZ(string)
    • OracleTimeStampLTZ(int, int, int)
    • OracleTimeStampLTZ(int, int, int, int, int, int)
    • OracleTimeStampLTZ(int, int, int, int, int, int, double)
    • OracleTimeStampLTZ(int, int, int, int, int, int, int)
    • OracleTimeStampLTZ(byte [ ])
  • OracleTimeStampLTZ Static Fields
    • MaxValue
    • MinValue
    • Null
  • OracleTimeStampLTZ Static Methods
    • Equals
    • GetLocalTimeZoneName
    • GetLocalTimeZoneOffset
    • GetSysDate
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • Parse
    • SetPrecision
  • OracleTimeStampLTZ Static Operators
    • operator+
    • operator + (OracleTimeStampLTZ, OracleIntervalDS)
    • operator + (OracleTimeStampLTZ, OracleIntervalYM)
    • operator + (OracleTimeStampLTZ, TimeSpan)
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator -
    • operator - (OracleTimeStampLTZ, OracleIntervalDS)
    • operator - (OracleTimeStampLTZ, OracleIntervalYM)
    • operator - (OracleTimeStampLTZ, TimeSpan)
  • OracleTimeStampLTZ Static Type Conversions
    • explicit operator OracleTimeStampLTZ
    • explicit operator OracleTimeStampLTZ(OracleTimeStamp)
    • explicit operator OracleTimeStampLTZ(OracleTimeStampTZ)
    • explicit operator OracleTimeStampLTZ(string)
    • implicit operator OracleTimeStampLTZ
    • implicit operator OracleTimeStampLTZ(OracleDate)
    • implicit operator OracleTimeStampLTZ(DateTime)
    • explicit operator DateTime
  • OracleTimeStampLTZ Properties
    • BinData
    • Day
    • IsNull
    • Hour
    • Millisecond
    • Minute
    • Month
    • Nanosecond
    • Second
    • Value
    • Year
  • OracleTimeStampLTZ Methods
    • AddDays
    • AddHours
    • AddMilliseconds
    • AddMinutes
    • AddMonths
    • AddNanoseconds
    • AddSeconds
    • AddYears
    • CompareTo
    • Equals
    • GetHashCode
    • GetDaysBetween
    • GetYearsBetween
    • ToOracleDate
    • ToOracleTimeStamp
    • ToOracleTimeStampTZ
    • ToString
    • ToUniversalTime
• OracleTimeStampTZ Structure
  • OracleTimeStampTZ Members
  • OracleTimeStampTZ Constructors
    • OracleTimeStampTZ(DateTime)
    • OracleTimeStampTZ(DateTime, string)
    • OracleTimeStampTZ(string)
    • OracleTimeStampTZ(int, int, int)
    • OracleTimeStampTZ(int, int, int, string)
    • OracleTimeStampTZ(int, int, int, int, int, int)
    • OracleTimeStampTZ(int, int, int, int, int, int, string)
    • OracleTimeStampTZ(int, int, int, int, int, int, double)
    • OracleTimeStampTZ(int, int, int, int, int, int, double, string)
    • OracleTimeStampTZ(int, int, int, int, int, int, int)
    • OracleTimeStampTZ(int, int, int, int, int, int, int, string)
    • OracleTimeStampTZ(byte [ ])
  • OracleTimeStampTZ Static Fields
    • MaxValue
    • MinValue
    • Null
  • OracleTimeStampTZ Static Methods
    • Equals
    • GetSysDate
    • GreaterThan
    • GreaterThanOrEqual
    • LessThan
    • LessThanOrEqual
    • NotEquals
    • Parse
    • SetPrecision
  • OracleTimeStampTZ Static Operators
    • operator +
    • operator +(OracleTimeStampTZ, OracleIntervalDS)
    • operator +(OracleTimeStampTZ, OracleIntervalYM)
    • operator +(OracleTimeStampTZ, TimeSpan)
    • operator ==
    • operator >
    • operator >=
    • operator !=
    • operator <
    • operator <=
    • operator -
    • operator - (OracleTimeStampTZ, OracleIntervalDS)
    • operator - (OracleTimeStampTZ, OracleIntervalYM)
    • operator - (OracleTimeStampTZ value1, TimeSpan value2)
  • OracleTimeStampTZ Static Type Conversions
    • explicit operator OracleTimeStampTZ
    • explicit operator OracleTimeStampTZ(OracleTimeStamp)
    • explicit operator OracleTimeStampTZ(OracleTimeStampLTZ)
    • explicit operator OracleTimeStampTZ(string)
    • implicit operator OracleTimeStampTZ
    • implicit operator OracleTimeStampTZ(OracleDate)
    • implicit operator OracleTimeStampTZ(DateTime)
    • explicit operator DateTime
  • OracleTimeStampTZ Properties
    • BinData
    • Day
    • IsNull
    • Hour
    • Millisecond
    • Minute
    • Month
    • Nanosecond
    • Second
    • TimeZone
    • Value
    • Year
  • OracleTimeStampTZ Methods
    • AddDays
    • AddHours
    • AddMilliseconds
    • AddMinutes
    • AddMonths
    • AddNanoseconds
    • AddSeconds
    • AddYears
    • CompareTo
    • Equals
    • GetDaysBetween
    • GetHashCode
    • GetTimeZoneOffset
    • GetYearsBetween
    • ToLocalTime
    • ToOracleDate
    • ToOracleTimeStampLTZ
    • ToOracleTimeStamp
    • ToString
    • ToUniversalTime
• INullable Interface
  • INullable Interface Members
  • INullable Interface Properties
    • IsNull

15 Oracle Data Provider for .NET Types Exceptions

• OracleTypeException Class
  • OracleTypeException Members
  • OracleTypeException Constructors
    • OracleTypeException(string)
    • OracleTypeException(SerializationInfo, StreamingContext)
  • OracleTypeException Static Methods
  • OracleTypeException Properties
    • Message
    • Source
  • OracleTypeException Methods
    • ToString
• OracleNullValueException Class
  • OracleNullValueException Members
  • OracleNullValueException Constructors
    • OracleNullValueException()
    • OracleNullValueException(string)
  • OracleNullValueException Static Methods
  • OracleNullValueException Properties
  • OracleNullValueException Methods
• OracleTruncateException Class
  • OracleTruncateException Members
  • OracleTruncateException Constructors
    • OracleTruncateException()
    • OracleTruncateException(string)
  • OracleTruncateException Static Methods
  • OracleTruncateException Properties
  • OracleTruncateException Methods

16 Oracle Data Provider for .NET UDT-Related Classes

• OracleCustomTypeMappingAttribute Class
  • OracleCustomTypeMappingAttribute Members
  • OracleCustomTypeMappingAttribute Constructors
    • OracleCustomTypeMappingAttribute(string)
  • OracleCustomTypeMappingAttribute Static Methods
  • OracleCustomTypeMappingAttribute Properties
    • UdtTypeName
  • OracleCustomTypeMappingAttribute Methods
• OracleObjectMappingAttribute Class
  • OracleObjectMappingAttribute Members
  • OracleObjectMappingAttribute Constructors
    • OracleObjectMappingAttribute(string)
    • OracleObjectMappingAttribute(int)
  • OracleObjectMappingAttribute Static Methods
  • OracleObjectMappingAttribute Properties
    • AttributeIndex
    • AttributeName
  • OracleObjectMappingAttribute Methods
• OracleArrayMappingAttribute Class
  • OracleArrayMappingAttribute Members
  • OracleArrayMappingAttribute Constructors
    • OracleArrayMappingAttribute()
  • OracleArrayMappingAttribute Static Methods
  • OracleArrayMappingAttribute Properties
  • OracleArrayMappingAttribute Methods
• IOracleCustomType Interface
  • IOracleCustomType Members
  • IOracleCustomType Interface Methods
    • FromCustomObject
    • ToCustomObject
• IOracleCustomTypeFactory Interface
  • IOracleCustomTypeFactory Members
  • IOracleCustomTypeFactory Interface Methods
    • CreateObject
• IOracleArrayTypeFactory Interface
  • IOracleArrayTypeFactory Members
  • IOracleArrayTypeFactory Interface Methods
    • CreateArray
    • CreateStatusArray
• OracleUdt Class
  • OracleUdt Members
  • OracleUDT Static Methods
    • GetValue
    • GetValue(OracleConnection, IntPtr, string)
    • GetValue(OracleConnection, IntPtr, int)
    • GetValue(OracleConnection, IntPtr, string, out object)
    • GetValue(OracleConnection, IntPtr, int, out object)
    • IsDBNull
    • IsDBNull(OracleConnection, IntPtr, string)
    • IsDBNull(OracleConnection, IntPtr, int)
    • SetValue
    • SetValue(OracleConnection, IntPtr, string, object)
    • SetValue(OracleConnection, IntPtr, int, object)
    • SetValue(OracleConnection, IntPtr, string, object, object)
    • SetValue(OracleConnection, IntPtr, int, object, object)
• OracleRef Class
  • OracleRef Members
  • OracleRef Constructors
    • OracleRef(OracleConnection, string)
    • OracleRef(OracleConnection, string, string)
  • OracleRef Static Fields
    • Null
  • OracleRef Static Methods
  • OracleRef Instance Properties
    • Connection
    • HasChanges
    • IsLocked
    • IsNull
    • ObjectTableName
    • Value
  • Oracle Ref Instance Methods
    • Clone
    • Delete
    • Dispose
    • Flush
    • GetCustomObject
    • GetCustomObject(OracleUdtFetchOption)
    • GetCustomObject(OracleUdtFetchOption, int)
    • GetCustomObjectForUpdate
    • GetCustomObjectForUpdate(bool)
    • GetCustomObjectForUpdate(bool, int)
    • IsEqual
    • Lock
    • Update
• OracleUdtFetchOption Enumeration
• OracleUdtStatus Enumeration

17 Oracle Data Provider for .NET Bulk Copy Classes

• OracleBulkCopy Class
  • OracleBulkCopy Members
  • OracleBulkCopy Constructors
    • OracleBulkCopy(OracleConnection)
    • OracleBulkCopy(string)
    • OracleBulkCopy(OracleConnection, OracleBulkCopyOptions)
    • OracleBulkCopy(string, OracleBulkCopyOptions)
  • OracleBulkCopy Properties
    • BatchSize
    • BulkCopyOptions
    • BulkCopyTimeout
    • ColumnMappings
    • Connection
    • DestinationTableName
    • NotifyAfter
  • OracleBulkCopy Public Methods
    • Close
    • Dispose
    • WriteToServer
    • WriteToServer(DataRow[])
    • WriteToServer(DataTable)
    • WriteToServer(IDataReader)
    • WriteToServer(DataTable, DataRowState)
    • WriteToServer(OracleRefCursor)
  • OracleBulkCopy Events
    • OracleRowsCopied
• OracleBulkCopyColumnMapping Class
  • OracleBulkCopyColumnMapping Members
  • OracleBulkCopyColumnMapping Constructors
    • OracleBulkCopyColumnMapping()
    • OracleBulkCopyColumnMapping(int, int)
    • OracleBulkCopyColumnMapping(int, string)
    • OracleBulkCopyColumnMapping(string, int)
    • OracleBulkCopyColumnMapping(string, string)
  • OracleBulkCopyColumnMapping Properties
    • DestinationColumn
    • DestinationOrdinal
    • SourceColumn
    • SourceOrdinal
• OracleBulkCopyColumnMappingCollection Class
  • OracleBulkCopyColumnMappingCollection Members
  • OracleBulkCopyColumnMappingCollection Properties
    • Item[index]
  • OracleBulkCopyColumnMappingCollection Public Methods
    • Add
    • Add(OracleBulkCopyColumnMapping)
    • Add(int, int)
    • Add(int, string)
    • Add(string, int)
    • Add(string, string)
    • Clear
    • Contains
    • CopyTo
    • IndexOf
    • Insert
    • Remove
    • RemoveAt
• OracleBulkCopyOptions Enumeration
• OracleRowsCopiedEventHandler Delegate
• OracleRowsCopiedEventArgs Class
  • OracleRowsCopiedEventArgs Members
  • OracleRowsCopiedEventArgs Constructors
    • OracleRowsCopiedEventArgs(long)
  • OracleRowsCopiedEventArgs Properties
    • Abort
    • RowsCopied

A Oracle Schema Collections

• Common Schema Collections
  • MetaDataCollections
  • DataSourceInformation
  • DataTypes
  • Restrictions
  • ReservedWords
• ODP.NET-Specific Schema Collection
  • Tables
  • Columns
  • Views
  • XMLSchema
  • Users
  • Synonyms
  • Sequences
  • Functions
  • Procedures
  • ProcedureParameters
  • Arguments
  • Packages
  • PackageBodies
  • JavaClasses
  • Indexes
  • IndexColumns
  • PrimaryKeys
  • ForeignKeys
  • ForeignKeyColumns
  • UniqueKeys

B Mapping LINQ Canonical Functions and Oracle Functions

Glossary

Index