This document is provided on an "AS IS" basis without warranties of any kind. Smartsite iXperion class libraries may change in future releases.

Syntax

C# Copy imageCopy Code
                                  public class OracleDatabase
Visual Basic (Declaration) Copy imageCopy Code
                                  Public Class OracleDatabase

The type exposes the following members.

Public Constructors

  Name Description
Public method OracleDatabase
Constructor that creates a new instance of an OracleDatabase.

Public Methods

  Name Description
Public method CreateAdapter
Creates an IDbDataAdapter instance for the current database server.
(Inherited from Database.)
Public method CreateCommand
Create an IDbCommand instance for the current database server.
(Inherited from Database.)
Public method CreateCommand
Creates an IDbCommand instance with the given connection..
(Inherited from Database.)
Public method CreateCommand
Creates an IDbCommand instance with the given transaction..
(Inherited from Database.)
Public method CreateCommand Obsolete.
Creates an IDbCommand instance with the given connection and transaction.
(Inherited from Database.)
Public method CreateCommand
Creates an IDbCommand instance with the given connection, transaction, command text and parameters set.
(Inherited from Database.)
Public method CreateConnection
Creates a connection and sets the product name and site name.
(Overrides Database..::CreateConnection()()()().)
Public method CreatePagingQuery
Not supported.
(Overrides Database..::CreatePagingQuery(String, String, Int32, Int32).)
Public method CreateParameter
Create an IDataParameter instance for the current database server.
(Inherited from Database.)
Public method CreateParameter
Create an IDataParameter instance for the current database server.
(Inherited from Database.)
Public method Equals (Inherited from Object.)
Public method ExecuteNonQuery
Executes the query. No resultset is returned.
(Inherited from Database.)
Public method ExecuteNonQuery
Executes the query. No resultset is returned.
(Inherited from Database.)
Public method ExecuteNonQuery
Executes the query. No resultset is returned.
(Inherited from Database.)
Public method ExecuteNonQuery
Executes the query. No resultset is returned.
(Inherited from Database.)
Public method ExecuteReader Overloaded.
Public method ExecuteScalar<(Of <<'(T>)>>)
Executes the query and returns a single value from the query.
(Inherited from Database.)
Public method ExecuteScalar<(Of <<'(T>)>>)
Executes the query and returns a single value from the query.
(Inherited from Database.)
Public method ExecuteScalar<(Of <<'(T>)>>)
Executes the query and returns an boolean value from the query.
(Inherited from Database.)
Public method ExecuteScalar<(Of <<'(T>)>>)
Executes the query and returns a value of type T from the query.
(Inherited from Database.)
Public method ExecuteStoredProcedure
Executes a stored procedure. The query parameters must be named parameters. The result is a datatable that contains all the output parameters and their values of the stored procedure.
(Inherited from Database.)
Public method GetCommand
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.)
Public method GetCommand
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.)
Public method GetCommand
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction and sets the given commandText.
(Inherited from Database.)
Public method GetCommand
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.)
Public method GetCommand
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction and sets the commandText and parameters.
(Inherited from Database.)
Public method GetHashCode (Inherited from Object.)
Public method GetIdentity Overloaded.
Public method GetParameterName
Returns a string containing the modified parameterName, matching the Oracle format.
(Overrides Database..::GetParameterName(String).)
Public method GetType (Inherited from Object.)
Public method Static member IsBooleanNumber
Returns true if the NUMBER with the given precision and scale is considered to be a Boolean.
Public method Static member IsDoubleNumber
Returns true if the NUMBER with the given precision and scale is considered to be a Double.
Public method Static member IsInt16Number
Returns true if the NUMBER with the given precision and scale is considered to be an Int16.
Public method Static member IsInt32Number
Returns true if the NUMBER with the given precision and scale is considered to be an Int32.
Public method Static member IsInt64Number
Returns true if the NUMBER with the given precision and scale is considered to be an Int64.
Public method Static member IsSingleNumber
Returns true if the NUMBER with the given precision and scale is considered to be a Single.
Public method NotifyAllTablesChanged
Notify this Database object that all the tables in the database have changed. This is useful when an unknown set of tables has been changed or when someone wants all the caches to be flushed.
(Inherited from Database.)
Public method NotifyTableChanged
This method is called if someone wishes to notify this Database instance that a row in a database table has changed. It is important to notify this Database to keep cached database tables up to date.
(Inherited from Database.)
Public method NotifyTableChanged
This method is called if someone wishes to notify this Database instance that a row in a database table has changed. It is important to notify this Database to keep cached database tables up to date.
(Inherited from Database.)
Public method PreparseQuery Overloaded.
Public method SetIdentityInsertOnOff
Sets the identity insert on or off.
(Overrides Database..::SetIdentityInsertOnOff(IDbConnection, IDbTransaction, String, Boolean).)
Public method ToString (Inherited from Object.)

Protected Methods

  Name Description
Protected method CreateConnectionBase
Creates a new connection.
(Inherited from Database.)
Protected method CreateMetaXml
Creates an Xml document containing a description of the database.
(Inherited from Database.)
Protected method ExecuteInternal
Calls the base.ExecuteInteral but add extra error handling.
(Overrides Database..::ExecuteInternal(ExecuteType, IDbCommand, DatabaseExecuteSettings, String, array<Object>[]()[][]).)
Protected method Finalize (Inherited from Object.)
Protected method GetCachedParsedQuery
Returns the cached parsed query from cache or null otherwise.
(Inherited from Database.)
Protected method GetObjectId Overloaded.
Protected method LogExecute
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.)
Protected method LogExecute
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.)
Protected method LogExecute
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.)
Protected method MakeDbNullable<(Of <<'(T>)>>) (Inherited from Database.)
Protected method MemberwiseClone (Inherited from Object.)
Protected method OnAfterExecuteStoredProcedure
Called after the stored procedure is called. Allows subclasses to modify the command object.
(Overrides Database..::OnAfterExecuteStoredProcedure(IDbCommand, DatabaseStoredProcedure).)
Protected method OnBeforeExecuteStoredProcedure
Called before the stored procedure is called. Allows subclasses to modify the command object.
(Overrides Database..::OnBeforeExecuteStoredProcedure(IDbCommand, DatabaseStoredProcedure).)
Protected method PreparseParameterizedQuery
Modifies a parameterized query to match the syntax of the current database server.
(Inherited from Database.)
Protected method PreparseParameterizedQuery
Modifies a parameterized query to match the syntax of the current database server.
(Inherited from Database.)
Protected method SetCachedParsedQuery
Adds the parsed query to the cache.
(Inherited from Database.)
Protected method SplitQueryOnParameters
Splits a parameterized query on the '?' symbol, ignoring any question marks in strings or comments. This method can be used by inheritors who must replace the '?' symbol by something else because their providers need that.
(Inherited from Database.)
Protected method SplitSqlStatements
Splits the sql query that consists multiple
(Overrides Database..::SplitSqlStatements(IDbCommand).)

Public Properties

  Name Description
Public property ConnectionString
Returns the connection string.
(Inherited from Database.)
Public property Id
Returns the Id of this database
(Inherited from Database.)
Public property IsCmsDatabase
Gets if this database is a CMS database. Once set to true, isCmsDatabase can never be set to false again.
(Inherited from Database.)
Public property Meta
Returns meta information about this database.
(Inherited from Database.)
Public property ProviderName
Gets the provider invariant name.
(Inherited from Database.)
Public property ServerType
Returns the DatabaseServerType.Oracle.
(Overrides Database..::ServerType.)
Public property ServerVersion
Gets the dbms version.
(Inherited from Database.)
Public property TableCache
Returns the TableCacheManager for this Database.
(Inherited from Database.)

Protected Properties

  Name Description
Protected property CustomVwSchemaProcedureParameters
Returns the sql query that retrieves data normally returned by VwSchemaProcedureParameters. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
(Inherited from Database.)
Protected property CustomVwSchemaProcedures
Returns the sql query that retrieves data normally returned by vwSchemaTables. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
(Inherited from Database.)
Protected property CustomVwSchemaTables
Returns the sql query that retrieves data normally returned by vwSchemaTables. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
(Overrides Database..::CustomVwSchemaTables.)
Protected property Factory
Gets the factory for this database.
(Inherited from Database.)
Protected property ParsedConnectionString
Gets the parsed connection string.
(Inherited from Database.)

Public Events

  Name Description
Public event TableChanged
Event that is raised when a row in a table in this database is changed.
(Inherited from Database.)

See Also

Advanced