Click or drag to resize

DatabaseExecCommands Enumeration

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
public enum DatabaseExecCommands
Members
  Member nameValueDescription
ClearPicklistCache1Clears the pick list cache
GetConnectionName2Returns a readable name for the current connection.
GetMinDateTime3Returns the minimum DateTime value supported by this DBMS.
ProviderConnectionString4Returns the provider-specific connection string for this DBMS.
DatabaseExceptionType5 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.
ValidateRepository6 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!
CrossDBFromClause7 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