ISQLCommandInstance

Assembly: Db;

Namespace: Prognoz.Platform.Interop.Db;

Description

The ISQLCommandInstance interface contains properties and methods used to execute and access results of procedures and DBMS commands.

Inheritance Hierarchy

ISQLCommandInstance

Comments

To execute DBMS procedures and commands, open corresponding repository object using the IMetabaseObjectDescriptor.Open or IMetabaseObjectDescriptor.OpenWithParam method and cast it to the ISQLCommandInstance interface. After that, to start execution, use the Execute method.

NOTE. On executing a big number of procedures and procedures with output parameters, it is recommended to use the DAL assembly method and not the ISQLCommandInstance interface.

Properties

	Property name	Brief description
	Database	The Database property returns an object allowing to get access to the objects stored in database.

Methods

	Method name	Brief description
	Execute	The Execute method runs object on execution and returns the quantity of processed records.

See also:

Db Assembly Interfaces | ISQLCommand | IProcedure