ISDatabaseProviderUtilitiesBase Class

The base class from which all Database Provider Utility classes must inherit.

Methods

Name Description
DatabaseNameValidate
DatabaseNameValidated Parse database name, remove any invalid characters.
Escape Escape (if necessary) a field or table name.
EscapeList Escapes (if necessary) a comma separated field list.
FormatSqlBoolean Format a Boolean value for use in an SQL string.
FormatSqlDate Format a Date value for use in an SQL string.
FormatSqlDecimal Format a Decimal value for use in an SQL string.
FormatSqlDouble Format a Double value for use in an SQL string.
FormatSqlInteger Format an Integer value for use in an SQL string.
FormatSqlLong Format an Long value for use in an SQL string.
FormatSqlShort Format a Short value for use in an SQL string.
FormatSqlString Format a String value for use in an SQL string.
GetCurrentDatabaseUsers Retrieves information about users currently logged in to the current database.
GetCurrentUtcDate Get the Current UTC (Co-ordinated Universal Time) Date and Time from the Database Server.
GetDatabaseLastBackupInformation Get last backup information from the database.
GetDatabaseList Retrieves a list of databases on the server specified in databaseConnectionInfo.
GetSchema Retrieves schema information for the current database.
GetServerGroupList Retrieves a list of Server Login Groups.
GetServerList Retrieves a list of database servers on the network.
GetSqlWhereFromRange
GetVersion Retrieves the version of the current database.
SoundEx Creates an SQL string containing this provider's equivalent of "Sounds Like" function.
SqlCase Creates an SQL string containing this provider's equivalent of an CHOOSE function.
SqlChoose Creates an SQL string containing this provider's equivalent of an CHOOSE function.
SqlIif Creates an SQL string containing this provider's equivalent of an Immediate If (Iif) function.
SqlLength Creates an SQL string containing this provider's equivalent of a string Len or Length function.
TranslateException Attempts to translate an Exception object raised by this provider into a friendlier Exception.
ValidateDatabaseConnectionInformation
ValidateSelectQuery Validate a Query is a valid 'SELECT' Query.
ValidateSimpleSqlWhereClause System Use Only Validate an SQL WHERE Clause conforms to the 'simple' notion and can therefore by used in such places as Range Lookups in finPOWER Connect Cloud.

Properties

Name Description
DefaultServerPort The Default TCP/IP Port to use when connecting to a Database Server which supports specification of a Server Port.
IsBeta Indicates whether this is a Beta provider.
ProviderText Read-Only
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0