Knight Data Access Layer
BaseStoredProcedureProvider Class Methods


KellermanSoftware.NetDataAccessLayer Namespace : BaseStoredProcedureProvider Class

For a list of all members of this type, see BaseStoredProcedureProvider members.

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 (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodChangeDatabase Change database. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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.BaseDatabaseProvider)
Public MethodCreateDatabase Create new database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodDatabaseExists Check database existance (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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.  
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  
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.BaseDatabaseProvider)
Public MethodGetAllForeignKeyConstraints Get all constraints for the current database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetColumnDefinitionSql Get portion of SQL used for the column definition for add column and create table sql (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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 MethodGetCreateSequenceSql Get the sql to create sequence (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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 with composite keys (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetCreateTableSqlWithPrimaryKey Get the SQL for creating a table with a primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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.BaseDatabaseProvider)
Public MethodGetDatabaseNameFromConnectionString Get database name from the connection string. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDatabases Get a list of databases for the current database server (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDatabaseServerDate Get the date of the database server (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDatabaseTables Get a list of tables in the current database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDatabaseTypeForDbType Get the database field type for the passed standard DbType (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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.BaseDatabaseProvider)
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.BaseDatabaseProvider)
Public MethodGetDropTableSql Get the sql to drop a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetDropTriggerSql Get the sql to drop a trigger (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetFieldType Get a .NET type associated with a string from a database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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 MethodGetRecordsFromSproc Get records from stored procedure using passed parameters  
Public MethodGetServerNameFromConnectionString Get the server name from the connection string (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetTruncateSql Get the sql to truncate a table. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodGetUpdateTablesSql Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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  
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 passed stored procedure exists in the database  
Public MethodTableExists Returns true if the passed table exists in the database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodTruncateTable Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodWrap Wrap a table name or field name in square brackets (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Top
Protected Methods
 NameDescription
Protected MethodAddConstraints Add constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodAddForeignKeyConstraints Adds the foreign key constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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.BaseDatabaseProvider)
Protected MethodGetPrimaryKeyColumnsForTable Get the primary key columns for a table from the schema (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodGetRecords Gets records using the given command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodGetStartBatchSql Get SQL for batch start (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
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

BaseStoredProcedureProvider Class
KellermanSoftware.NetDataAccessLayer Namespace

 

 

©2021. Kellerman Software. All Rights Reserved.

Product Website