Knight Data Access Layer
OracleProvider Class Members
Properties  Methods 


KellermanSoftware.NetDataAccessLayer.Providers Namespace : OracleProvider Class

The following tables list the members exposed by OracleProvider.

Public Constructors
 NameDescription
Public ConstructorOracleProvider Constructor Perform initialization of the Provider  
Top
Public Properties
 NameDescription
Public PropertyConnection Get a reference to the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyConnectionString The connection string (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyDatabaseName Returns database name (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public PropertyDirtyReadClause Oracle does not support dirty reads (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public PropertyFriendlyProviderName Get a friendly name for the provider (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public PropertyIsConnectionOpen True if the connection is open (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyIsFileBasedDatabase The database is not a single file (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public PropertyIsInTransaction True if we are inside a transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyLicenseKey The license key for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyParameterPrefix The default parameter prefix for Oracle is the colon character, : (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public PropertySupportComments Returns true if the provider supports comments (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyTransaction Get a reference to the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public PropertyUserName The user name for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Top
Protected Properties
 NameDescription
Protected PropertyIsBatchMode Returns true if batch mode is active (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Top
Public Methods
 NameDescription
Public MethodBeginTransaction Begin a new transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodBuildDatabaseSpecificConnectionString Build a connection string based on the passed in database (Just returns the connection string for Oracle) (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodChangeDatabase Change database (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodClearLogOverloaded.  Clear the file log (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodCloseConnection Close the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodCommitTransaction Commit the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodConnectionValid Opens and closes the connection to ensure it is valid. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodCountRecordsInTable Get the number of records in a table (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodCreateDatabase Create new database (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodDatabaseExists Check database existance (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodDisableLogging Disable all logging (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodDispose Close the connection on Dispose (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodDropTable Drop (remove) a table from the database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodEnableLoggingOverloaded.  Log to the console (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodExecuteNonQueryOverloaded.  Execute the passed query and return the number of affected records (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodExecuteNonQuerySprocOverloaded.  Execute the passed stored procedure and return the number of affected records. Output parameters will be set on return. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider)
Public MethodExecuteScalarOverloaded.  Execute the passed query and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodExecuteScalarSprocOverloaded.  Execute the passed stored procedure and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider)
Public MethodFillDataTableOverloaded.  Fill a data table with the passed sql and parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodForeignKeyExists Returns true if the Foreign Key Exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetAddColumnSql Get the SQL for adding a column to an existing table (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetAllForeignKeyConstraints Get all the foreign key constrains for the database (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetColumnDefinitionSql Get portion of SQL used for the column definition for add column and create table sql (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetCommentLine Get sql comment using the given comment text (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetCommentSeparatorLine Get comment separator line (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetCreateIndexSql Get the SQL to create the passed in index (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetCreateSequenceSql Get the sql to create sequence (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetCreateTableSql Get the SQL for creating a table with the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetCreateTableSqlWithCompositeKey Get the SQL for creating a table without a primary key (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetCreateTableSqlWithPrimaryKey Get the SQL for creating a table with a primary key (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetCreateTablesSql Get the SQL to create the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetCreateTriggerSql Get the sql to create trigger (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDatabaseNameFromConnectionString Get database name from the connection string (Always returns null for Oracle) (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDatabases Get a list of databases for the database server (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDatabaseServerDate Get the date from the database server (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDatabaseTables Get a list of tables for the current connection (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDatabaseTypeForDbType Get the database field type for the passed standard DbType (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDataTableOverloaded.  Get a datatable from the passed sql (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDbType Get a DbType associated with a string from a database (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDbTypeForClrType Get the DbType for provided ClrType (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDropSequenceSql Get the sql to drop a sequence (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDropTableSql Get the sql to drop a table (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetDropTriggerSql Get the sql to drop a trigger (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetFieldType Get a .NET type associated with a string from a database (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetIdentity Get the identity for the last inserted record (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetIdentitySql Get the SQL used to get the identity for the last inserted record (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetIndexesForTable Gets the indexes for a table. (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetMaxPrimaryKey Get the maximum value for the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetMaxPrimaryKeySql Get the SQL required to get the maximum value of the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetOracleCreateTableSqlWithCompositeKey Get the SQL for creating a table with composite keys (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetPagingSql Generate SQL that will get a page of records (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetRecordsFromSproc Get records from stored procedure using passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider)
Public MethodGetRowNumberClause Get a row number clause for a provider (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetServerNameFromConnectionString Get the server name from the connection string (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetTruncateSql Get the sql to truncate a table. (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodGetUpdateTablesSql Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodIndexExists Detect if an index exists (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodLoadOverloaded.  Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodLoadFromSprocOverloaded.  Get records by stored procedure with the passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider)
Public MethodLoadOneOverloaded.  Get a single record from a table with a parameterized where clause (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodLoadPage Get a page of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodLoadTopOverloaded.  Get a limited number of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodMarkForeignKeys Mark foreign key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodMarkPrimaryKey Mark Primary Key in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodMarkPrimaryKeys Mark primary key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOpenConnection Open the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodRecordExistsOverloaded.  Returns true if the record exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodRollbackTransaction Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodStoredProcedureExists Returns true if the stored procedure exists (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodTableExists Returns true if the table exists (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Public MethodTruncateTable Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodWrap For Oracle table names and field names are not wrapped in square brackets or back ticks (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Top
Protected Methods
 NameDescription
Protected MethodAddConstraints Add constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodAddForeignKeyConstraints Adds the foreign key constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Protected MethodAddOtherFieldsThanPrimaryKey Build the sql for fields other than the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodAddParameters Adds parameters to the given command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodBuildTopRecordsSql Builds the top records SQL. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodCreateCommand Creates new command with the given command text (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodCreateConnection Creates new connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodCreateDataAdapter Creates data adapter using the given select command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodGetEndBatchSql Get SQL for batch end (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Protected MethodGetPrimaryKeyColumnsForTable Get the primary columns by the schema (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Protected MethodGetRecords Gets records using the given command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodGetStartBatchSql Get SQL for batch start (Inherited from KellermanSoftware.NetDataAccessLayer.Providers.BaseOracleProvider)
Protected MethodInterceptSql Intercept the SQL and change it with the passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodSetParameter Sets parameter using the given parameter value (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Top
See Also

Reference

OracleProvider Class
KellermanSoftware.NetDataAccessLayer.Providers Namespace

 

 

©2021. Kellerman Software. All Rights Reserved.

Product Website