IProcedure

Assembly: Db;

Namespace: Prognoz.Platform.Interop.Db;

Description

The IProcedure interface contains properties and methods of the Procedure repository object.

IProcedure

When a new procedure is created, to ensure its correct work, determine the following minimum set of properties in the settings:

	Property name	Brief description
	External	The External property returns whether the procedure is external.
	ForceCreate	The ForceCreate property determines whether it is possible to create incorrect procedure.
	Kind	The Kind property determines the type of created object: function or procedure.
	NativeName	The NativeName property determines a physical name of procedure in a database.

	Property name	Brief description
	Database	The Database property determines the database, in which DBMS command is stored.
	Text	The Text property determines the text of SQL query for certain DBMS driver.

	Method name	Brief description
	AlterProcedure	The AlterProcedure method updates the procedure text in a database according to the procedure text in repository.
	AttachProcedure	The AttachProcedure method updates information about procedure structure in repository, according to procedure structure on a DB server.
	CreateProcedure	The CreateProcedure method creates a procedure in the database on the basis of available metadata.
	DropProcedure	The DropProcedure method removes a procedure from database on server.
	Refresh	The Refresh method completes the update by saving all changes.
	UpdateProcedure	The UpdateProcedure method updates the structure of procedure on a database server according to structure of current procedure.

	Method name	Brief description
	ClearText	The ClearText method clears the operator of DBMS command.