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) |
Executes query and returns the number of affected rows.
| |
ExecuteNonQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Runs the query.
| |
ExecuteQuery(QueryParameters) |
Executes query and returns result as a dataset.
| |
ExecuteQuery(String, QueryDataParameters, QueryMacros) |
Executes query and returns result as a dataset.
| |
ExecuteQuery(String, QueryDataParameters, QueryTypeEnum, Boolean) |
Runs the query.
| |
ExecuteQuery(String, QueryDataParameters, QueryMacros, Int32, Int32, Int32 ) |
Executes query and returns result as a dataset.
| |
ExecuteQueryInternal |
Runs the query.
| |
ExecuteReader(QueryParameters, CommandBehavior) |
Runs the query and returns result as Data reader. Keeps the connection open.
| |
ExecuteReader(String, QueryDataParameters, QueryMacros, CommandBehavior) |
Executes query and returns result as a data reader. Keeps the connection open.
| |
ExecuteReader(String, QueryDataParameters, QueryTypeEnum, CommandBehavior) |
Runs the query and returns result as Data reader. Keeps the connection open.
| |
ExecuteScalar(QueryParameters) |
Runs the query and returns result as a single value.
| |
ExecuteScalar(String, QueryDataParameters, QueryMacros) |
Executes query and returns result as a a single value.
| |
ExecuteScalar(String, QueryDataParameters, QueryTypeEnum, Boolean) |
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 Type of the current instance. (Inherited from 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 Object. (Inherited from 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 | |
---|---|---|
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