NET Refactor - Automate Calling of Existing Stored Procedures

Use Stored Procedures Instead of Dynamic SQL

In the case where you or someone else has already written a Stored Procedure, NET Refactor can generate the calling code to call that procedure (SqlServer only at this time).

To invoke this feature, simply select the Call Stored Procedure menu under Sql Refactor menu in NET Refactor. Once the Dialog is displayed, copy your Stored Procedure code from Sql Exlplorer, Enterprise Manager, etc. Paste the Stored Procedure into the top text window of the dialog. Check the type of language that you wish to generate. This will already be set if you had a VB.NET or C# code window active in the IDE before loading the dialog. Click the Generate button.

The resultant calling code will be displayed in the bottom text window as shown in Figure 1. Click the Copy button to copy the calling code to the Clipboard and paste it into a code window in the IDE.  NET Refactor does not automatically paste the code into a code window for you because no code originated from a code window, and therefore there is no code window associated with this feature.

Figure 1 - Generate Stored Procedure Calling Code.