| 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(QueryParameters) |
Runs the query.
|
| ExecuteNonQuery(String, QueryDataParameters, QueryMacros) | Obsolete.
Executes query and returns the number of affected rows.
|
| ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) | Obsolete.
Runs the query.
|
| 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.
|
| ExecuteQuery(String, QueryDataParameters, QueryMacros) | Obsolete.
Executes query and returns result as a dataset.
|
| ExecuteQuery(QueryInfo, QueryDataParameters, QueryMacros) | Obsolete.
Executes query and returns result as a dataset.
|
| ExecuteQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) | Obsolete.
Runs the query.
|
| ExecuteQuery(String, QueryDataParameters, QueryMacros, Int32, Int32, Int32) | Obsolete.
Executes query and returns result as a dataset.
|
| ExecuteReader(QueryParameters, CommandBehavior) |
Runs the query and returns result as Data reader. Keeps the connection open.
|
| ExecuteReader(String, QueryDataParameters, QueryMacros, CommandBehavior) | Obsolete.
Executes query and returns result as a data reader. Keeps the connection open.
|
| ExecuteReader(String, QueryDataParameters, QueryTypeEnum, CommandBehavior) | Obsolete.
Runs the query and returns result as Data reader. Keeps the connection open.
|
| ExecuteReader(QueryInfo, QueryDataParameters, QueryMacros, CommandBehavior) | Obsolete.
Executes query and returns result as a data reader. Keeps the connection open.
|
| ExecuteScalar(QueryParameters) |
Runs the query and returns result as a single value.
|
| ExecuteScalar(String, QueryDataParameters, QueryMacros) | Obsolete.
Executes query and returns result as a a single value.
|
| ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean) | Obsolete.
Runs the query.
|
| 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.
|
Extension Methods| Name | Description | |
|---|---|---|
 | AsValue |
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.) |
| GetAPIString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| GetString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| ToBoolean |
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDateTime |
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDouble |
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToGuid |
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToInteger |
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToString |
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.) |
See Also