Click or drag to resize
AbstractDataConnection Methods

The AbstractDataConnection type exposes the following members.

Methods
  NameDescription
Protected methodAddParameters
Adds the given parameters to the SQL command
Public methodBeginTransaction
Begins a new transaction.
Public methodBeginTransaction(IsolationLevel)
Begins a new transaction.
Public methodBulkInsert
Performs a bulk insert of the data into a target database table
Protected methodCheckThreadSafety
Checks the thread safety of current operation.
Public methodClose
Closes connection to the database.
Public methodCommitTransaction
Commits current transaction.
Protected methodCreateCommand
Creates a new SQL command
Protected methodCreateDataAdapter
Creates a data adapter
Protected methodCreateNativeConnection
Creates a new native connection
Protected methodCreateParameter(DataParameter)
Creates a SQL parameter from the given data parameter
Protected methodCreateParameter(String, Object)
Creates a new command parameter
Public methodDispose
Disposes the connection object.
Public methodExecuteNonQuery
Executes the query and returns the number of rows affected.
Public methodExecuteNonQueryAsync

An asynchronous version of ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) which executes the query asynchronously and returns the number of rows affected.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

Public methodExecuteQuery
Returns result of the query.
Public methodExecuteReader
Executes the query and returns result of the query as a DbDataReader.
Public methodExecuteReaderAsync

An asynchronous version of ExecuteReader(String, QueryDataParameters, QueryTypeEnum, CommandBehavior) which executes the query asynchronously and returns result as a DbDataReader.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

Public methodExecuteScalar
Executes the query and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
Public methodExecuteScalarAsync

An asynchronous version of ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean), which executes the query asynchronously and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

Public methodGetExecutingConnection
Gets the connection that executes the given query
Public methodGetNestedConnection
Gets the nested connection with the given connection string
Public methodGetXmlSchema
Returns XML schema for specified table.
Protected methodHandleDbError
Handles the database error. Returns false, if the error was not handled
Protected methodHandleError
Handles the error. Returns false, if the error was not handled
Public methodIsOpen
Returns true if connection to the database is open.
Public methodIsTransaction
Indicates if transaction is running.
Protected methodLoadDefaultConnectionString
Loads the default connection string
Public methodLogConnectionOperation
Logs the connection operation to the query log.
Public methodNativeConnectionExists
Returns true if the native connection exists.
Public methodNativeDBConnectionExists
Returns true if the native connection exists.
Public methodOpen
Opens connection to the database.
Protected methodPrepareCommand
Prepares the SQL command for the query.
Public methodRollbackTransaction
Rollbacks current transaction.
Protected methodSetParameterType
Sets the parameter type to a destination type
Protected methodValidateTransaction
Validates the transaction
Top
See Also