DatabaseExecCommands Enumeration |
Namespace:
NetQuarry
Assembly:
EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax public enum DatabaseExecCommands
Public Enumeration DatabaseExecCommands
Members
| 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).
-
Flags - Ignored, use zero for future compatibility.
-
Param #1 - The data source against which the cross-DB query is to be performed from this database.
You can provide either a live IDatabase object, or the DatabaseID of the database
which will be used to obtain the IDatabase object from the IAppContext.Databases collection.
-
Param #2 - The FROM clause (without the FROM keyword).
|
See Also