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: 8.2.23

Syntax

public abstract class AbstractDataConnection : IDataConnection, 
	IDisposable, INotCopyThreadItem

The AbstractDataConnection type exposes the following members.

Constructors

	Name	Description
Protected method	AbstractDataConnection	Constructor.

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
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	Returns result of the query.
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	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
Protected method	CheckThreadSafety	Checks the thread safety of current operation.
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

Extension Methods

	Name	Description
Public Extension Method	AsValue	Converts object to a query value which can be used as a query parameter (Defined by QueryExtensions.)
Public Extension Method	GetAPIString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	GetString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	ToBoolean	Returns the boolean representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDateTime	Returns the DateTime representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDouble	Returns the double representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToGuid	Returns the Guid representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToInteger	Returns the integer representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToString	Returns the string representation of an object or default value if not. (Defined by CoreExtensions.)

Fields

	Name	Description
Protected field	mAdvancedSettings	Advanced settings.
Protected field	mCommandTimeout	Command timeout.
Protected field	mConnectionCreated	If true, the connection was created from this object
Protected field	mConnectionString	Connection string for specific provider.
Protected field	mConnectionStringName	Connection string name
Protected field	mLastError	Last connection error
Protected field	mLocalTransaction	SqlTransaction object.
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	mOriginalThreadID	Original thread ID of the connection.
Protected field	mUseScopeConnection	If true, the connection uses the scope connection

Properties

	Name	Description
Public property	AdvancedSettings	Advanced settings.
Public property	CommandTimeout	Command timeout.
Public property	ConnectionCreated	If true, some connection was used
Public property	ConnectionGUID	Connection GUID
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	LocalAdvancedSettings	Local advanced settings.
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