| GeneralConnection Methods |
The GeneralConnection type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | BulkInsert |
Performs a bulk insert of the data into a target database table
|
| Close |
Closes the connection.
|
| Dispose |
Disposes the connection
|
| ExecuteNonQuery |
Executes the query and returns the number of rows affected.
|
| ExecuteNonQueryAsync | An asynchronous version of ExecuteNonQuery(QueryParameters) which 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(QueryParameters, Int32) |
Executes query and returns result as a DataSet. Returns the total number of result items.
|
| ExecuteReader |
Executes the query and returns result of the query as a DbDataReader.
|
| ExecuteReaderAsync | An asynchronous version of ExecuteReader(QueryParameters, CommandBehavior) which 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 |
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 | An asynchronous version of ExecuteScalar(QueryParameters), which 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. |
| GetExecutingConnection |
Gets the connection that executes the given query
|
| GetObjectData |
Gets object data.
|
| IsOpen |
Returns true if the connection is open.
|
| LogQueryEnd |
Logs the end of the query processing.
|
| LogQueryStart |
Logs query start. Logs the query to the file and to current request log for debugging.
|
| Open |
Opens the connection.
|
 | RunQuery |
Runs the query against SQL DB.
|
See Also