IDbStoredProcedureManager Interface
Represents a stored procedure manager interface for a database provider.
Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)
Syntax
'Declaration
Public Interface IDbStoredProcedureManager
'Usage
Dim instance As IDbStoredProcedureManager
public interface IDbStoredProcedureManager
public interface class IDbStoredProcedureManager
public interface IDbStoredProcedureManager
The IDbStoredProcedureManager type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
DropProcedure | Removes a stored procedure from a database. |
|
GetStoredProcedureCreateFromExistingStatement | Returns the CREATE PROCEDURE definition for a new stored procedure that is based on an existing stored procedure. |
|
GetStoredProcedureCreateStatement | Returns the CREATE PROCEDURE template for creating a new stored procedure. |
|
GetStoredProcedureEditStatement | Returns the ALTER PROCEDURE statement for a stored procedure. |
|
GetStoredProcedureExecStatement | Returns the EXECUTE statement for a stored procedure. |
|
GetStoredProcedureParameters | Returns a collection of parameters for a stored procedure. |
|
GetStoredProcedures | Returns a collection of stored procedures for a database. |
Top
Remarks
In order to manage stored procedures, you need to implement IDbStoredProcedureManager on the class that you derived from DatabaseProvider. Stored procedures are collections of SQL code that execute on the server, and are often used instead of queries. For example, you could create a stored procedure that performs a query that is based on values that are calculated from parameters that you pass to the stored procedure.
Notes for Implementers
If your provider implements the IDbStoredProcedureManager interface, your provider must also implement all of the following members: