The ConnectionHelper type exposes the following members.
Back to Top
Back to Top
Back to Top
Methods
| Name | Description | |
|---|---|---|
  | BulkInsert |
Performs a bulk insert of the data into a target database table
|
| Clear |
Clears the connection helper cache
|
| ExecuteNonQuery(String, QueryDataParameters, QueryMacros) |
Executes query and returns the number of affected rows.
|
| ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Executes query and returns the number of affected rows.
|
| ExecuteQuery(QueryParameters) |
Executes query and returns result as a dataset.
|
| ExecuteQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Runs the query.
|
| ExecuteQuery(String, QueryDataParameters, String, String, Int32, String) |
Executes query and returns result as a dataset.
|
| ExecuteQuery(String, QueryDataParameters, String, String, Int32, String, Int32, Int32, Int32 ) |
Executes query and returns result as a dataset.
|
| ExecuteReader |
Executes query and returns the results in a DataSet.
|
| ExecuteScalar(String, QueryDataParameters, QueryMacros) |
Executes query and returns result as a a single value.
|
| ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Executes query and returns result as a a single value.
|
| GetConnection |
Returns the connection.
|
| GetConnectionByName |
Returns the connection.
|
| GetConnectionString(String) |
Gets the connection string
|
| GetConnectionString(String, Boolean) |
Gets the connection string
|
| GetConnectionString(SQLServerAuthenticationModeEnum, String, String, String, String, Int32, Boolean, String, Boolean) |
Generates the connection string with the specified parameters.
|
| GetConnectionStringPrefix |
Gets the connection string name for the given domain
|
| GetFirstFoundConnectionString |
Gets the first found connection string by the prefix, if none found, returns null
|
| GetIsolationLevel |
Returns the isolation level evaluated from the string representation.
|
| GetSqlConnectionString |
Returns the connection string.
|
| GetSqlConnectionString(String) |
Returns the connection string.
|
| InitRequestContext |
Initializes the request context to use proper database based on current domain name
|
| TestConnection(String) |
Tests the given connection parameters.
|
| TestConnection(SQLServerAuthenticationModeEnum, String, String, String, String) |
Tests the given connection parameters.
|
| UpdateAll |
Runs the update all query of the given class name
|
Fields
| Name | Description | |
|---|---|---|
 | DEFAULT_CONNECTIONSTRING_NAME |
Default connection string name
|
| DefaultCommandTimeout |
Command timeout for the SQL commands.
|
| DisposeConnectionAfterClose |
If true, disposes connection after the connection is closed.
|
| 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).
|
| KeepContextConnectionOpen |
If true, the connection is opened only once for the entire request and kept open until the end of the request.
|
| 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.
|
| TransactionIsolationLevel |
Isolation level for SQL operations with transactions.
|
| UseContextConnection |
If true, single connection is used for the entire request.
|
Properties
| Name | Description | |
|---|---|---|
 | ConnectionAvailable |
Returns true if the connection is available.
|
| ConnectionString |
Global connection string.
|
| ConnectionStringName |
Global connection string name
|
| ConnectionStringPrefix |
Global connection string prefix
|
| IsConnectionStringInitialized |
Indicates whether connection string is initialized or not.
|
| OpenedConnections |
Number of the opened connections.
|
| OpenedTransactions |
Number of the opened transactions.
|
See Also