IDbStoredProcedureManager.GetStoredProcedureExecStatement Method

Article
05/02/2012

Returns the EXECUTE statement for a stored procedure.

Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)

Syntax

'Declaration
Function GetStoredProcedureExecStatement ( _
    connectionString As String, _
    schema As String, _
    storedProcedureName As String, _
    parameters As IList(Of StoredProcedureParameter) _
) As Query
'Usage
Dim instance As IDbStoredProcedureManager
Dim connectionString As String
Dim schema As String
Dim storedProcedureName As String
Dim parameters As IList(Of StoredProcedureParameter)
Dim returnValue As Query

returnValue = instance.GetStoredProcedureExecStatement(connectionString, _
    schema, storedProcedureName, parameters)

Query GetStoredProcedureExecStatement(
    string connectionString,
    string schema,
    string storedProcedureName,
    IList<StoredProcedureParameter> parameters
)

Query^ GetStoredProcedureExecStatement(
    String^ connectionString, 
    String^ schema, 
    String^ storedProcedureName, 
    IList<StoredProcedureParameter^>^ parameters
)

function GetStoredProcedureExecStatement(
    connectionString : String, 
    schema : String, 
    storedProcedureName : String, 
    parameters : IList<StoredProcedureParameter>
) : Query

Parameters

connectionString
Type: System.String
The connection string for the database.

schema
Type: System.String
The schema name for the stored procedure.
Note If schema is empty, the default schema name will be used.

storedProcedureName
Type: System.String
The name of the stored procedure.

parameters
Type: System.Collections.Generic.IList<StoredProcedureParameter>
An IList object that contains the list of StoredProcedureParameter objects.

Return Value

Type: Microsoft.Web.Management.DatabaseManager.Query
A Query object that contains the EXECUTE statement for a stored procedure.

Remarks

All database providers that implement the IDbStoredProcedureManager interface must also implement the GetStoredProcedureExecStatement method. This method returns an EXECUTE statement that is based on the parameters that you specify in parameters.

Notes for Implementers

If your provider does not support executing stored procedures, you can use the following code sample to raise a not-implemented exception:

public Query GetStoredProcedureExecStatement(string connectionString, string schema, string storedProcedureName, IList<StoredProcedureParameter> parameters)

{

throw new NotImplementedException();

}

Note

See the EXECUTE (Transact-SQL) topic for more information about the EXECUTE SQL statement.

Permissions

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Share via