| 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 the query and returns the number of rows affected.
|
| ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Executes the query and returns the number of rows affected.
|
| ExecuteNonQueryAsync(String, CancellationToken, QueryDataParameters, QueryMacros) | Executes the query asynchronously and returns the number of rows affected. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. |
| ExecuteNonQueryAsync(String, QueryDataParameters, QueryTypeEnum, CancellationToken, Boolean) | Executes the query asynchronously and returns the number of rows affected. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. |
| 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 the query and returns result of the query as a DbDataReader.
|
| ExecuteReaderAsync | Executes the query asynchronously and returns result as a DbDataReader. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. |
| ExecuteScalar(String, QueryDataParameters, QueryMacros) |
Executes the query and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
|
| ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Executes the query and returns the first column of the first row in the result set returned by the query.
Additional columns or rows are ignored.
|
| ExecuteScalarAsync(String, CancellationToken, QueryDataParameters, QueryMacros) | Executes the query asynchronously and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. |
| ExecuteScalarAsync(String, QueryDataParameters, QueryTypeEnum, CancellationToken, Boolean) | Executes the query asynchronously and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. |
| 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