ISDatabaseBL Class - finPOWER Connect Business Layer

A handler for opening and communicating with an Intersoft application database.

All database access is restricted to read-only operations apart from updating information in the Registry table.

Methods

	Name	Description
	AuditLogAdd System Use Only
	CreateDataTableFromCollection	Create a DataTable from a collection that implements ICollection.
	CreateDataViewFromCollection	Create a DataView from a collection.
	CreateDataViewFromCollectionSimple	Create a DataView from a collection.
	CreateDataViewFromNamedGlobalCollection	Gets a DataView from a named Global Collection.
	CreateDeleteQueryBuilderForCustomTable	Create an ISDeleteQueryBuilder object that can be used to delete records from custom database tables only.
	CreateLock
	CreateSelectQueryBuilder
	CreateServiceLogsFromXml System Use Only	Create a Service Log from a XML string.
	CreateSqlWhereBuilder	Create an ISSqlWhereBuilder object using the current database provider.
	CreateSqlWhereBuilderForDataView	Create an ISSqlWhereBuilder object using the MS Jet 4 database provider.
	CreateToken System Use Only	Create a Token in the ISToken table for the Current User.
	CreateUnionSelectQuery	Create a Union Select Query.
	CreateUpdateQueryBuilderForCustomTable	Create an ISUpdateQueryBuilder object that can be used to update custom database tables only.
	CurrentProviderUtilities
	DataReaderClose	Close and dispose of a DataReader.
	DataReaderOpen System Use Only	Open a disconnected DataReader.
	DataSetFlatten	Flatten out a hierarchical DataSet (with a maximum of 1 child level) into a DataSet containing a single table with columns added from the child table(s).
	DataSetOpen System Use Only
	DataTableClose	Close and dispose of a DataTable.
	DataTableOpen System Use Only
	DataTableSetColumns	Specifies the Columns to be included in a Data Table (i.e., remove unwanted columns) and also the ordinal positions of the Columns.
	DataTablesCombineHorizontal	Combine DataTables horizontally i.e. create a DataTable that contains all columns from both of the supplied DataTables.
	DataTablesCombineHorizontal2	Combine DataTables horizontally i.e. create a DataTable that contains all columns from both of the supplied DataTables.
	DataTablesCombineVertical	Combine DataTables vertically i.e. create a DataTable that contains all rows from both of the supplied DataTables.
	DatabaseConnectionInfoGenerate System Use Only
	DatabaseConnectionInfoResolve	Resolves the Database Configuration file properties, if applicable.
	DatabaseCopy	Make a copy of a Database.
	DatabaseCopyCurrent	Make a copy of the Current Database.
	DatabasePermissionsReset	Reset Database permissions.
	Escape	Escape (if necessary) a field or table name.
	EscapeList	Escapes (if necessary) a comma separated field list.
	FormatSqlBoolean
	FormatSqlDate
	FormatSqlDecimal
	FormatSqlDouble
	FormatSqlInteger
	FormatSqlIntegerBoolean
	FormatSqlLong
	FormatSqlShort
	FormatSqlString
	GenerateExtendedIndexes	Generate Extended Indexes as defined in the ISIndex table.
	GetCurrentDatabaseLocks	Creates an ISDatabaseLocks collection.
	GetCurrentUtcDate	Get the current UTC (Co-ordinated Universal Time) Date and Time from the Database Server.
	GetFieldBoolean
	GetFieldDate
	GetFieldDateNullable
	GetFieldDecimal
	GetFieldDouble
	GetFieldEnum
	GetFieldInteger
	GetFieldIntegerBoolean
	GetFieldLong
	GetFieldString	Returns a String value for a Record's Column. A DBNull value is treated as a blank string.
	GetFieldUtcDate
	GetIdFromPk	Get a record's Id from its Primary Key.
	GetIsRelatedServiceLog	Indicates whether a Service Log is related to another, i.e. they have the same parent.
	GetLatestChildServiceLog	Retrieve the latest successful child Service Log of a Service Log.
	GetPkFromId	Get a record's Primary Key from its Id.
	GetRecordCount
	GetScalarBoolean	Retrieve a single Boolean value from the Database.
	GetScalarDate	Retrieve a single Date value from the Database.
	GetScalarDecimal	Retrieve a single Decimal value from the Database.
	GetScalarDouble	Retrieve a single Double value from the Database.
	GetScalarEnum	Retrieve a single Enum value from the Database.
	GetScalarInteger	Retrieve a single Integer value from the Database.
	GetScalarIntegerBoolean	Retrieve a single Boolean value from the Database where the Boolean value is represented by an Integer on the Database.
	GetScalarLong	Retrieve a single Long value from the Database.
	GetScalarString	Retrieve a single String value from the Database.
	GetServiceLog	Retrieve a Service Log records based upon its ServiceLogPk.
	GetServiceLogForCallback	Retrieve a Service Log Pk for a Callback.
	GetServiceLogResponseBinaryData	Retrieve the Binary Response Data from a Service Log record.
	GetServiceLogServiceSummary	Retrieves Service Log Summary for Services used within the last X days.
	GetServiceLogs	Retrieve Service Log records based upon a ServiceLogPk.
	GetServiceLogsByFilters	Retrieve Service Log records based upon a series of filters.
	GetSqlWhereFromRange
	IsConnectionAlive	Returns True if the Database Connection is alive.
	LinksGet	Retrieve items from the ISLink table.
	LockCheck	Check a Lock.
	LockClear	Clear a Lock.
	PerformHealthCheck System Use Only	Checks to see if the Configuration Table can be read.
	ProcessedExternalUpdate	Updates a ProcessedExternal flag on the specified table.
	ProviderUtilities
	RecordIdValid	Validate a Record Id and optionally convert it to upper case.
	RecordIdValidate	Validates that a Record Id is valid and checks that it does not already exist in the Database.
	RecordsetClose	Close and release the reference to an ADO Recordset.
	RecordsetOpen	Open an ADO Recordset.
	RegistryGetString
	RegistrySetString	Saves information in the database Registry table.
	SqlCase	Creates an SQL string containing this provider's equivalent of an CASE function.
	SqlChoose	Creates an SQL string containing this provider's equivalent of an CHOOSE function.
	SqlIif	Generate an IIF (or equivalent) SQL block.
	SqlLength	Generate a LEN (or LENGTH) SQL expression.
	TokenValidate	Validate a Token.
	TransactionBegin	Begins a Database Transaction.
	TransactionCommit
	TransactionRollback
	UpdatePendingServiceLogAsFailed	Fail a "Pending" Service Log record.

Properties

	Name	Description
	DataReaderOpenCount Read-Only
	DatabaseIndex1 Read-Only
	DatabaseIndex2 Read-Only
	DatabaseName Read-Only	The Name of the current Database.
	ExclusiveDetails Read-Only	If another user has an Exclusive lock on the Database, this provides details of that User.
	ExclusiveWarning Read-Only	Indicates whether the database has an Exclusive Lock made by another User.
	GetDatabaseConnectionInfo Read-Only System Use Only
	InTransaction Read-Only	Indicates whether the database is in a Transaction.
	IntersoftConnectionString Read-Only	The full Database Connection string used by Intersoft.
	IsBeta Read-Only	Indicates whether this is a Beta Database.
	IsDatabaseEngineReadOnly Read-Only	Indicates whether the database is Read-Only due to File System or Database Engine permissions.
	IsExclusive Read-Only	Indicates whether this Database is open in Exclusive mode.
	IsOpen Read-Only	Indicates whether a database is currently open.
	IsReadOnly Read-Only	Indicates whether the database is Read-Only.
	Provider Read-Only
	ProviderText Read-Only
	RequiresUpgradePostProcess Read-Only	Indicates whether this database is awaiting post-processing after an upgrade.
	ServerName Read-Only
	ServerPort Read-Only
	SupportsGetCurrentUtcDateTime Read-Only	Indicates whether this Provider can supply the current UTC Date and time, and therefore the GetCurrentUtcDate method
	TransactionNestedLevel Read-Only	Returns the number of levels of nested Database Transactions currently active.

Namespace:: Intersoft.ISSupport6
Assembly:: ISSupport6, Version=6.0.3
Target Framework:: .NET 9.0