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: 9.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.

Fields

	Name	Description
Protected field	mConnectionGuid	Connection GUID to identify the connection.
Protected field	mDataConnection	Data connection for specific provider.

Properties

	Name	Description
Public property	AdvancedSettings	Advanced settings.
Public property	CacheDependency	Cache dependency for the cached items.
Public property	CacheMinutes	Cache minutes for which the selected data should be cached (only for SELECT queries).
Public property	CommandTimeout	Command timeout.
Public property	ConnectionGuid	Connection GUID to identify the connection.
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	FireErrorOnExecute	If true, an error if fired on execution (for debug purposes).
Public property	KeepOpen	If true, the connection stays open even if close is requested.
Public property	UserID	ID of the current user.
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	Runs the query.
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	Runs the query and returns result as Data reader. Keeps the connection open.
Public method	ExecuteScalar	Runs the query and returns result as a single value.
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.