procedure Prepare

Usage

Call the Prepare method to have ElevateDB allocate resources for the execution of a procedure/function, compile the procedure/function, and perform the process of setting up the procedure/function for execution. The procedure/function is specified via the StoredProcName property.

ElevateDB automatically prepares a procedure/function if it is executed without first being prepared. After execution, ElevateDB unprepares the procedure/function. When a procedure/function will be executed a number of times, an application should always explicitly prepare the procedure/function using the Prepare method to avoid multiple and unnecessary prepares and unprepares.

Preparing a procedure/function consumes some database resources, so it is good practice for an application to unprepare a procedure/function once it is done using it. The UnPrepare method unprepares a procedure/function.