IDataConnection Interface

Data connection interface that must be implemented by data providers.

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

Syntax

public interface IDataConnection : IDisposable

The IDataConnection type exposes the following members.

Properties

	Name	Description
Public property	AdvancedSettings	Advanced connection settings.
Public property	CommandTimeout	Command timeout.
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 affected rows.
Public method	ExecuteQuery	Returns result of the query.
Public method	ExecuteReader	Returns result of the query as a Data reader. Keeps the connection open.
Public method	ExecuteScalar	Returns a single value result of the query.
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.