The GeneralConnection type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | GeneralConnection(String) |
Constructor.
|
 | GeneralConnection(SerializationInfo, StreamingContext) |
Constructor for deserialization.
|
Methods
| Name | Description | |
|---|---|---|
| BulkInsert |
Performs a bulk insert of the data into a target database table
|
| Close |
Closes the connection.
|
| Dispose |
Disposes the connection
|
|  Equals | (Inherited from Object.) |
| 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.
|
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetExecutingConnection |
Gets the connection that executes the given query
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetObjectData |
Gets object data.
|
| GetType | Gets the (Inherited from Type of the current instance.Object.) |
| 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.
|
| MemberwiseClone | Creates a shallow copy of the current (Inherited from Object.Object.) |
| Open |
Opens the connection.
|
| RunQuery |
Runs the query against SQL DB.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
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.) |
Fields
| Name | Description | |
|---|---|---|
 | mConnectionGuid |
Connection GUID to identify the connection.
|
| mDataConnection |
Data connection for specific provider.
|
Properties
| Name | Description | |
|---|---|---|
 | AdvancedSettings |
Advanced settings.
|
| CacheDependency |
Cache dependency for the cached items.
|
| CacheMinutes |
Cache minutes for which the selected data should be cached (only for SELECT queries).
|
| CommandTimeout |
Command timeout.
|
| ConnectionGuid |
Connection GUID to identify the connection.
|
| ConnectionString |
Connection string for specific provider.
|
| DataConnection |
Data connection for specific provider.
|
| DisableConnectionDebug |
If true, the debug is disabled on this connection
|
| DisableQueryDebug |
If true, the debug of the executed queries is disabled on this connection
|
| FireErrorOnExecute |
If true, an error if fired on execution (for debug purposes).
|
| KeepOpen |
If true, the connection stays open even if close is requested.
|
| UserID |
ID of the current user.
|
| UseScopeConnection |
If true, the connection uses the scope connection
|
See Also