| ConnectionHelper Methods |
The ConnectionHelper type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | BuildConnectionString |
Builds a connection string based on specified parameters.
|
| 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 of provided connectionStringName.
|
| GetConnectionString(String, Boolean) |
Gets the connection string of provided connectionStringName.
|
| 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.
|
See Also