DatabaseExecCommands Enumeration |
Namespace: NetQuarry
Member name![]() | Value![]() | Description | |
---|---|---|---|
ClearPicklistCache | 1 | Clears the pick list cache | |
GetConnectionName | 2 | Returns a readable name for the current connection. | |
GetMinDateTime | 3 | Returns the minimum DateTime value supported by this DBMS. | |
ProviderConnectionString | 4 | Returns the provider-specific connection string for this DBMS. | |
DatabaseExceptionType | 5 | Returns the DBMS-independent DatabaseExceptionTypes value correponding to the Exception provided as Param1. Note that only a few important Exceptions have been mapped so most Exceptions will result in a zero return indicating that the Exception is not specifically recognized. | |
ValidateRepository | 6 | Validates that this database is the NetQuarry Repository database for this application. If the database is not a NetQuarry repository database then an appropriate exception is thrown! | |
CrossDBFromClause | 7 |
Modified the FROM clause for use in a cross-DB query from this database against the another database.
If both databases are the same database the returned FROM clause will be unmodified.
Currently a cross-DB FROM clause modification is only supported where both IDatabase objects have
the same DBMSType and only for SQL-Server. If the cross-DB query is not supported then the
FROM clause will be returned unmodified. For example, for a SQL-Server cross-DB query the FROM clause users
against database called "registration" will be returned as registration.dbo.users. Note that a SQL-Server
WITH(NOLOCK) or similar hint should not interfere with the cross-DB modification, e.g. users WITH(NOLOCK)
yields registration.dbo.users WITH(NOLOCK).
|