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 Code |
---|---|
public class OracleDatabase |
Visual Basic (Declaration) | Copy Code |
---|---|
Public Class OracleDatabase |
The type exposes the following members.
Public Constructors
Name | Description | |
---|---|---|
OracleDatabase |
Constructor that creates a new instance of an OracleDatabase.
|
Public Methods
Name | Description | |
---|---|---|
CreateAdapter |
Creates an IDbDataAdapter instance for the current database server.
(Inherited from Database.) |
|
CreateCommand |
Create an IDbCommand instance for the current database server.
(Inherited from Database.) |
|
CreateCommand |
Creates an IDbCommand instance with the given connection..
(Inherited from Database.) |
|
CreateCommand |
Creates an IDbCommand instance with the given transaction..
(Inherited from Database.) |
|
CreateCommand |
Obsolete.
Creates an IDbCommand instance with the given connection and transaction.
(Inherited from Database.) |
|
CreateCommand |
Creates an IDbCommand instance with the given connection, transaction, command text and parameters set.
(Inherited from Database.) |
|
CreateConnection |
Creates a connection and sets the product name and site name.
(Overrides Database..::CreateConnection()()()().) |
|
CreatePagingQuery |
Not supported.
(Overrides Database..::CreatePagingQuery(String, String, Int32, Int32).) |
|
CreateParameter |
Create an IDataParameter instance for the current database server.
(Inherited from Database.) |
|
CreateParameter |
Create an IDataParameter instance for the current database server.
(Inherited from Database.) |
|
Equals | (Inherited from Object.) | |
ExecuteNonQuery |
Executes the query. No resultset is returned.
(Inherited from Database.) |
|
ExecuteNonQuery |
Executes the query. No resultset is returned.
(Inherited from Database.) |
|
ExecuteNonQuery |
Executes the query. No resultset is returned.
(Inherited from Database.) |
|
ExecuteNonQuery |
Executes the query. No resultset is returned.
(Inherited from Database.) |
|
ExecuteReader | Overloaded. | |
ExecuteScalar<(Of <<'(T>)>>) |
Executes the query and returns a single value from the query.
(Inherited from Database.) |
|
ExecuteScalar<(Of <<'(T>)>>) |
Executes the query and returns a single value from the query.
(Inherited from Database.) |
|
ExecuteScalar<(Of <<'(T>)>>) |
Executes the query and returns an boolean value from the query.
(Inherited from Database.) |
|
ExecuteScalar<(Of <<'(T>)>>) |
Executes the query and returns a value of type T from the query.
(Inherited from Database.) |
|
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.) |
|
GetCommand |
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.) |
|
GetCommand |
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.) |
|
GetCommand |
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction and sets the given commandText.
(Inherited from Database.) |
|
GetCommand |
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction.
(Inherited from Database.) |
|
GetCommand |
Creates an IDbCommand instance on a new connection or joins an existing ambient transaction and sets the commandText and parameters.
(Inherited from Database.) |
|
GetHashCode | (Inherited from Object.) | |
GetIdentity | Overloaded. | |
GetParameterName |
Returns a string containing the modified parameterName, matching the Oracle format.
(Overrides Database..::GetParameterName(String).) |
|
GetType | (Inherited from Object.) | |
IsBooleanNumber |
Returns true if the NUMBER with the given precision and scale is considered to be a Boolean.
|
|
IsDoubleNumber |
Returns true if the NUMBER with the given precision and scale is considered to be a Double.
|
|
IsInt16Number |
Returns true if the NUMBER with the given precision and scale is considered to be an Int16.
|
|
IsInt32Number |
Returns true if the NUMBER with the given precision and scale is considered to be an Int32.
|
|
IsInt64Number |
Returns true if the NUMBER with the given precision and scale is considered to be an Int64.
|
|
IsSingleNumber |
Returns true if the NUMBER with the given precision and scale is considered to be a Single.
|
|
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.) |
|
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.) |
|
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.) |
|
PreparseQuery | Overloaded. | |
SetIdentityInsertOnOff |
Sets the identity insert on or off.
(Overrides Database..::SetIdentityInsertOnOff(IDbConnection, IDbTransaction, String, Boolean).) |
|
ToString | (Inherited from Object.) |
Protected Methods
Name | Description | |
---|---|---|
CreateConnectionBase |
Creates a new connection.
(Inherited from Database.) |
|
CreateMetaXml |
Creates an Xml document containing a description of the database.
(Inherited from Database.) |
|
ExecuteInternal |
Calls the base.ExecuteInteral but add extra error handling.
(Overrides Database..::ExecuteInternal(ExecuteType, IDbCommand, DatabaseExecuteSettings, String, array<Object>[]()[][]).) |
|
Finalize | (Inherited from Object.) | |
GetCachedParsedQuery |
Returns the cached parsed query from cache or null otherwise.
(Inherited from Database.) |
|
GetObjectId | Overloaded. | |
LogExecute |
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.) |
|
LogExecute |
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.) |
|
LogExecute |
Log the given IDbCommand object to the logging subsystem.
(Inherited from Database.) |
|
MakeDbNullable<(Of <<'(T>)>>) | (Inherited from Database.) | |
MemberwiseClone | (Inherited from Object.) | |
OnAfterExecuteStoredProcedure |
Called after the stored procedure is called. Allows subclasses to modify
the command object.
(Overrides Database..::OnAfterExecuteStoredProcedure(IDbCommand, DatabaseStoredProcedure).) |
|
OnBeforeExecuteStoredProcedure |
Called before the stored procedure is called. Allows subclasses to modify
the command object.
(Overrides Database..::OnBeforeExecuteStoredProcedure(IDbCommand, DatabaseStoredProcedure).) |
|
PreparseParameterizedQuery |
Modifies a parameterized query to match the syntax of the current database server.
(Inherited from Database.) |
|
PreparseParameterizedQuery |
Modifies a parameterized query to match the syntax of the current database server.
(Inherited from Database.) |
|
SetCachedParsedQuery |
Adds the parsed query to the cache.
(Inherited from Database.) |
|
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.) |
|
SplitSqlStatements |
Splits the sql query that consists multiple
(Overrides Database..::SplitSqlStatements(IDbCommand).) |
Public Properties
Name | Description | |
---|---|---|
ConnectionString |
Returns the connection string.
(Inherited from Database.) |
|
Id |
Returns the Id of this database
(Inherited from Database.) |
|
IsCmsDatabase |
Gets if this database is a CMS database. Once set to true, isCmsDatabase can never be set to false again.
(Inherited from Database.) |
|
Meta |
Returns meta information about this database.
(Inherited from Database.) |
|
ProviderName |
Gets the provider invariant name.
(Inherited from Database.) |
|
ServerType |
Returns the DatabaseServerType.Oracle.
(Overrides Database..::ServerType.) |
|
ServerVersion |
Gets the dbms version.
(Inherited from Database.) |
|
TableCache |
Returns the TableCacheManager for this Database.
(Inherited from Database.) |
Protected Properties
Name | Description | |
---|---|---|
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.) |
|
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.) |
|
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.) |
|
Factory |
Gets the factory for this database.
(Inherited from Database.) |
|
ParsedConnectionString |
Gets the parsed connection string.
(Inherited from Database.) |
Public Events
Name | Description | |
---|---|---|
TableChanged |
Event that is raised when a row in a table in this database is changed.
(Inherited from Database.) |
See Also
Smartsite.Data Namespace