IDataConnection Interface

Data connection interface that must be implemented by data providers.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0

Syntax

public interface IDataConnection : IDisposable

The IDataConnection type exposes the following members.

Properties

	Name	Description
Public property	CommandTimeout	Command timeout which will be set on this connection.
Public property	ConnectionString	Connection string for specific provider.
Public property	ConnectionStringName	Connection string for specific provider.
Public property	DisableConnectionDebug	If true, the debug is disabled on this connection
Public property	DisableQueryDebug	If true, the debug of queries is disabled on this connection
Public property	KeepOpen	If true, the connection stays open even if close is requested.
Public property	NativeConnection	Native connection object. It depends on provider type.
Public property	Transaction	Transaction object.
Public property	UseScopeConnection	If true, the connection uses the scope connection

Methods

	Name	Description
Public method	BeginTransaction()	Begins a new transaction.
Public method	BeginTransaction(IsolationLevel)	Begins a new transaction with specified isolation level.
Public method	BulkInsert	Performs a bulk insert of the data into a target database table
Public method	Close	Closes connection to the database.
Public method	CommitTransaction	Commits current transaction.
Public method	ExecuteNonQuery	Executes the query and returns the number of rows affected.
Public method	ExecuteNonQueryAsync	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 method	ExecuteQuery	Returns result of the query.
Public method	ExecuteReader	Executes the query and returns result as a DbDataReader.
Public method	ExecuteReaderAsync	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 method	ExecuteScalar	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 method	ExecuteScalarAsync	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 method	GetExecutingConnection	Gets the connection that executes the given query
Public method	GetXmlSchema	Returns XML schema for specified table.
Public method	IsOpen	Returns true if connection to the database is open.
Public method	IsTransaction	Indicates if transaction is running.
Public method	NativeConnectionExists	Returns true if the native connection exists.
Public method	NativeDBConnectionExists	Returns true if the native connection exists.
Public method	Open	Opens connection to the database.
Public method	RollbackTransaction	Rollbacks current transaction.