ConnectionHelper Class

Connection helper class.

Inheritance Hierarchy

System.Object
  CMS.DataEngine.ConnectionHelper

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

Syntax

public static class ConnectionHelper

The ConnectionHelper type exposes the following members.

Fields

	Name	Description
Public field Static member	DEFAULT_CONNECTIONSTRING_NAME	Default connection string name
Public field Static member	DefaultCommandTimeout	Command timeout for the SQL commands.
Public field Static member	DisposeConnectionAfterClose	If true, disposes connection after the connection is closed.
Public field Static member	CheckThreadSafety	If true, the thread safety of the connection access is checked (the connection must be used only in thread where it was originally created).
Public field Static member	KeepContextConnectionOpen	If true, the connection is opened only once for the entire request and kept open until the end of the request.
Public field Static member	LongRunningCommandTimeout	Command timeout in seconds for the SQL queries which are known to possibly take more time than standard command timeout. Long running queries have to be explicitly wrapped with CMSConnectionScope with its CommandTimeout property set to this value.
Public field Static member	TransactionIsolationLevel	Isolation level for SQL operations with transactions.
Public field Static member	UseContextConnection	If true, single connection is used for the entire request.

Properties

	Name	Description
Public property Static member	ConnectionAvailable	Returns true if the connection is available.
Public property Static member	ConnectionString	Global connection string.
Public property Static member	ConnectionStringName	Global connection string name
Public property Static member	ConnectionStringPrefix	Global connection string prefix
Public property Static member	IsConnectionStringInitialized	Indicates whether connection string is initialized or not.
Public property Static member	OpenedConnections	Number of the opened connections.
Public property Static member	OpenedTransactions	Number of the opened transactions.

Methods

	Name	Description
Public method Static member	BuildConnectionString	Builds a connection string based on specified parameters.
Public method Static member	BulkInsert	Performs a bulk insert of the data into a target database table
Public method Static member	Clear	Clears the connection helper cache
Public method Static member	ExecuteNonQuery(String, QueryDataParameters, QueryMacros)	Executes query and returns the number of affected rows.
Public method Static member	ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean)	Executes query and returns the number of affected rows.
Public method Static member	ExecuteQuery(QueryParameters)	Executes query and returns result as a dataset.
Public method Static member	ExecuteQuery(String, QueryDataParameters, QueryTypeEnum, Boolean)	Runs the query.
Public method Static member	ExecuteQuery(String, QueryDataParameters, String, String, Int32, String)	Executes query and returns result as a dataset.
Public method Static member	ExecuteQuery(String, QueryDataParameters, String, String, Int32, String, Int32, Int32, Int32)	Executes query and returns result as a dataset.
Public method Static member	ExecuteReader	Executes query and returns the results in a DataSet.
Public method Static member	ExecuteScalar(String, QueryDataParameters, QueryMacros)	Executes query and returns result as a a single value.
Public method Static member	ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean)	Executes query and returns result as a a single value.
Public method Static member	GetConnection	Returns the connection.
Public method Static member	GetConnectionByName	Returns the connection.
Public method Static member	GetConnectionString(String)	Gets the connection string of provided connectionStringName.
Public method Static member	GetConnectionString(String, Boolean)	Gets the connection string of provided connectionStringName.
Public method Static member	GetConnectionStringPrefix	Gets the connection string name for the given domain
Public method Static member	GetFirstFoundConnectionString	Gets the first found connection string by the prefix, if none found, returns null
Public method Static member	GetIsolationLevel	Returns the isolation level evaluated from the string representation.
Public method Static member	GetSqlConnectionString()	Returns the connection string.
Public method Static member	GetSqlConnectionString(String)	Returns the connection string.
Public method Static member	InitRequestContext	Initializes the request context to use proper database based on current domain name
Public method Static member	TestConnection(String)	Tests the given connection parameters.
Public method Static member	TestConnection(SQLServerAuthenticationModeEnum, String, String, String, String)	Tests the given connection parameters.