GeneralConnection Class

Represents a general database connection.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.GeneralConnection

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

Syntax

[SerializableAttribute]
public class GeneralConnection : ISerializable, 
	IDataConnection, IDisposable

The GeneralConnection type exposes the following members.

Constructors

	Name	Description
Protected method	GeneralConnection(String)	Constructor.
Public method	GeneralConnection(SerializationInfo, StreamingContext)	Constructor for deserialization.

Properties

	Name	Description
Public property	CommandTimeout	Command timeout.
Public property	ConnectionString	Connection string for specific provider.
Public property	DataConnection	Data connection for specific provider.
Public property	DisableConnectionDebug	If true, the debug is disabled on this connection
Public property	DisableQueryDebug	If true, the debug of the executed queries is disabled on this connection
Public property	KeepOpen	If true, the connection stays open even if close is requested.
Public property	UseScopeConnection	If true, the connection uses the scope connection

Methods

	Name	Description
Public method	BulkInsert	Performs a bulk insert of the data into a target database table
Public method	Close	Closes the connection.
Public method	Dispose	Disposes the connection
Public method	ExecuteNonQuery	Executes the query and returns the number of rows affected.
Public method	ExecuteNonQueryAsync	An asynchronous version of ExecuteNonQuery(QueryParameters) 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(QueryParameters)	Executes query and returns result as a dataset.
Public method	ExecuteQuery(QueryParameters, Int32)	Executes query and returns result as a DataSet. Returns the total number of result items.
Public method	ExecuteReader	Executes the query and returns result of the query as a DbDataReader.
Public method	ExecuteReaderAsync	An asynchronous version of ExecuteReader(QueryParameters, 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(QueryParameters), 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	GetObjectData	Gets object data.
Public method	IsOpen	Returns true if the connection is open.
Public method	LogQueryEnd	Logs the end of the query processing.
Public method	LogQueryStart	Logs query start. Logs the query to the file and to current request log for debugging.
Public method	Open	Opens the connection.
Protected method	RunQuery	Runs the query against SQL DB.