The DbNetData class is used to encapsulate a database connection with a suite of methods and properties
that use the connection.
Declaration Syntax| C# | Visual Basic |
public class DbNetData : IDisposable
Public Class DbNetData _ Implements IDisposable
Members| All Members | Constructors | Methods | Properties | Fields | Events |
| Icon | Member | Description |
|---|---|---|
 | DbNetData()()() |
Creates an instance of DbNeData by deriving the connection string from the configuration file using the name DbNetData
|
| DbNetData(String) |
Creates an instance of DbNeData without provider information
|
| DbNetData(String, DataProvider) |
Creates an instance of DbNeData with the data provider specified
|
| DbNetData(String, DataProvider, DatabaseType) |
Creates an instance of DbNeData with the data provider specified and the database
|
 | Adapter |
implemented by provider
|
| AllowUnqualifiedUpdates |
Prevents accidental execution of unqualified update/delete statements
|
| ApplyBatchUpdate()()() |
Applys the batch of updates
|
| BeginTransaction()()() |
Starts a database transaction
|
| Close()()() |
Closes the connection
|
| CloseConnectionOnError |
If set to true then the connection is automatically closed if an error occurs
|
| Command |
implemented by provider
|
| CommandDurationWarningThreshold |
The threshold in milliseconds above which details of commands executing for longer will be logged
|
| Commit()()() |
Commits a database transaction
|
| Conn |
implemented by provider
|
 | ConnectionString |
The connection string (after any path mappings have been made)
|
| ConvertEmptyToNull |
Converts empty string to null values in update statements when set to true
|
| Database |
The type of database connected to
|
| DatabaseVersion |
Returns the major version number for the database
|
| DataSourcePath |
The fully mapped path to the data source
|
| DeriveParameters(String) |
Derives the parameters for a stored procedure
|
| Dispose()()() | |
| ExecuteDelete(String) |
Deletes record from the table using the supplied SQL statement
|
| ExecuteDelete(CommandConfig) |
Deletes record from the table using the supplied CommandConfig
|
| ExecuteDelete(String, IDictionary) |
Deletes record from the table using the supplied parameterised statement and parameter values
|
| ExecuteInsert(String) |
Inserts a record into the database using the supplied insert statement
|
| ExecuteInsert(CommandConfig) |
Inserts a record into the database using the supplied CommandConfig
|
| ExecuteInsert(String, IDictionary) |
Inserts a record into the database using the supplied table name and parameters
|
| ExecuteNonQuery(CommandConfig) |
Executes and ad-hoc SQL statement that does not return a record set.
|
| ExecuteNonQuery(String) |
Executes and ad-hoc SQL statement that does not return a record set.
|
| ExecuteNonQuery(String, IDictionary) |
Executes and ad-hoc SQL statement that does not return a record set.
|
| ExecuteNonQuery(String, Boolean) |
Executes and ad-hoc SQL statement that does not return a record set.
|
| ExecuteNonQuery(String, IDictionary, Boolean) |
Executes and ad-hoc SQL statement that does not return a record set.
|
| ExecuteQuery(CommandConfig) |
Executes a select statement or stored procedure that returns a record set. Uses the CommandConfig argument to encapsulate the
command text and any parameter values.
|
| ExecuteQuery(QueryCommandConfig) |
Executes a select statement or stored procedure that returns a record set. Uses the CommandConfig argument to encapsulate the
command text, parameter values and command behavior.
|
| ExecuteQuery(String) |
Executes a select statement or stored procedure
|
| ExecuteQuery(String, IDictionary) |
Executes a parameterised select statement or stored procedure
|
| ExecuteQuery(String, IDictionary, CommandBehavior) |
Executes a parameterised select statement or stored procedure with a specified command behavior
|
| ExecuteSingletonQuery(String) |
Executes a select statement or stored procedure and reads the first row of the returned record set
|
| ExecuteSingletonQuery(CommandConfig) |
Executes a select statement or stored procedure and reads the first row of the returned record set
|
| ExecuteSingletonQuery(String, IDictionary) |
Executes a select statement or stored procedure and reads the first row of the returned record set
|
| ExecuteUpdate(UpdateCommandConfig) |
Executes an SQL update statement built using the supplied UpdateCommandConfig object
|
| ExecuteUpdate(String) |
Executes an SQL update statement
|
| ExecuteUpdate(String, IDictionary) |
Executes update statement built using the supplied SQL statement and parameters
|
| ExecuteUpdate(String, IDictionary, IDictionary) |
Executes update statement built using the supplied SQL statement and seperate update value and filter parameters
|
| GetDataSet(String) |
Returns a DataSet for the supplied SQL statement
|
| GetDataSet(QueryCommandConfig) |
Returns a DataSet for the supplied QueryCommandConfig
|
| GetDataSet(String, IDictionary) |
Returns a DataSet for the supplied SQL statement and parameter values
|
| GetDataTable(String) |
Returns a DataTable for the supplied SQL statement
|
| GetDataTable(QueryCommandConfig) |
Returns a DataTable for the supplied QueryCommandConfig
|
| GetDataTable(String, IDictionary) |
Returns a DataTable for the supplied SQL statement and parameter values
|
| GetSchemaTable(String) |
Returns a DataTable containing column metadata for the supplied SQL statement/table name
|
| GetSchemaTable(String, ListDictionary) |
Returns a DataTable containing column metadata for the supplied SQL statement/table name and parameters
|
| GetSequenceValue(String, Boolean) |
Returns the next or current Oracle sequence value
|
| Identity |
The autoincrementing value assigned to the last inserted record (where applicable). Only set if [!:DbNetLink.DbNetData.ReturnAutoIncrementValue] is set to true
|
| IsBatchUpdateSupported |
Indicates if database provider supports batch updates
|
| IsReservedWord(String) |
Returns true if the Token parameter is a reserved word in the database
|
| MetaDataCollection(MetaDataType) |
Returns a DataTable containing database metadata of the specified type
|
| MetaDataCollection(String) |
Returns a DataTable containing database metadata of the specified type
|
| NameDelimiterTemplate |
The template used to qualify database object names containing spaces
|
 | OnCommandConfigured |
OnCommandConfigured event can be used to customise the configuration of the command just prior to it being executed.
|
| Open()()() |
Opens the database connection
|
| ParameterName(String) |
Returns then corresponding database parameter name for the supplied token
|
| ParseParameters(String) |
Parses the Sql statement for parameter names and returns a corresponding paramater collection
|
| Provider |
The data provider used for the connection
|
| QualifiedDbObjectName(String) |
Qualifies a database object name to ensure that it can can be used in an SQL Statement.
|
| Reader |
implemented by provider
|
| ReaderValue(String) |
Returns the value for the current row in the Reader for the specified column name
|
| ReaderValue(Int32) |
Returns the value for the current row in the Reader for the specified column index
|
| ReservedWords |
Returns a list of reserved words for the database
|
| ReturnAutoIncrementValue |
Determines if an attempt is made to fetch the value assigned by an autoincrementing column after an insert
|
| Rollback()()() |
Rolls back a database transaction
|
| RowsAffected |
The number of rows affected by the last [!:DbNetLink.DbNetData.ExecuteDelete(string)] or [!:DbNetLink.DbNetData.ExecuteUpdate(string)] method
|
| SetParamValue(ListDictionary, String, Object) |
Sets the value of a parameter in a collection irrespective of case-sensitivity and whether the parameter is a simple
value or IDbDataParameter object
|
| SummaryExceptionMessage |
Controls the level of detail shown in any exceptions
|
| Transaction |
implemented by provider
|
| UnqualifiedDbObjectName(String) |
Removes the qualifiers from a database object name.
|
| UnqualifiedDbObjectName(String, Boolean) |
Removes the qualifiers from a database object name.
|
| UpdateBatchSize |
Specifies the batch size for batch updates.
|
| UserTableFilter()()() |
Creates a vendor independent filter string for the Tables metadata collection to select on "user" tables.
|
| VerboseErrorInfo |
Controls the verbosity of the error message
|
Inheritance Hierarchy| Object | |
 | DbNetData |