AbstractDataConnection Class

Represents SQL Server data connection.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.AbstractDataConnection
    CMS.DataProviderSQL.DataConnection

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

Syntax

public abstract class AbstractDataConnection : IDataConnection, 
	IDisposable, INotCopyThreadItem

The AbstractDataConnection type exposes the following members.

Constructors

	Name	Description
Protected method	AbstractDataConnection	Constructor.

Fields

	Name	Description
Protected field	mCommandTimeout	Command timeout.
Protected field	mConnectionString	Connection string for specific provider.
Protected field	mConnectionStringName	Connection string name
Protected field	mLastError	Last connection error
Protected field	mNativeConnection	Native connection object. It depends on provider type.
Protected field	mNestedConnections	Nested connections indexed by the connection string [connectionString -> IDbConnection]
Protected field	mNestedConnectionsList	List of nested connections
Protected field	mNestedOpenConnections	List of nested connections that were automatically opened
Protected field	mNestedOpenTransactions	List of nested connections that were automatically opened with transaction
Protected field	mUseScopeConnection	If true, the connection uses the scope connection

Properties

	Name	Description
Public property	CommandTimeout	Command timeout.
Public property	ConnectionString	Connection string for specific provider.
Public property	ConnectionStringName	Connection string name
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.
Protected property	LocalKeepOpen	If true, the connection stays open even if close is requested.
Protected property	LocalTransaction	Transaction object of local instance.
Public property	NativeConnection	Native connection object. It depends on provider type.
Protected property	NativeDBConnection	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
Protected method	AddParameters	Adds the given parameters to the SQL command
Public method	BeginTransaction()	Begins a new transaction.
Public method	BeginTransaction(IsolationLevel)	Begins a new transaction.
Public method	BulkInsert	Performs a bulk insert of the data into a target database table
Protected method	CheckThreadSafety	Checks the thread safety of current operation.
Public method	Close	Closes connection to the database.
Public method	CommitTransaction	Commits current transaction.
Protected method	CreateCommand	Creates a new SQL command
Protected method	CreateDataAdapter	Creates a data adapter
Protected method	CreateNativeConnection	Creates a new native connection
Protected method	CreateParameter(DataParameter)	Creates a SQL parameter from the given data parameter
Protected method	CreateParameter(String, Object)	Creates a new command parameter
Public method	Dispose	Disposes the connection object.
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 of the query 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	GetNestedConnection	Gets the nested connection with the given connection string
Public method	GetXmlSchema	Returns XML schema for specified table.
Protected method	HandleDbError	Handles the database error. Returns false, if the error was not handled
Protected method	HandleError	Handles the error. Returns false, if the error was not handled
Public method	IsOpen	Returns true if connection to the database is open.
Public method	IsTransaction	Indicates if transaction is running.
Protected method	LoadDefaultConnectionString	Loads the default connection string
Public method	LogConnectionOperation	Logs the connection operation to the query log.
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.
Protected method	PrepareCommand	Prepares the SQL command for the query.
Public method	RollbackTransaction	Rollbacks current transaction.
Protected method	SetParameterType	Sets the parameter type to a destination type
Protected method	ValidateTransaction	Validates the transaction