Product Documentation

FairCom C# Stored Procedures

Previous Topic

Next Topic

Altering the SP, UDF, or Trigger

During development, it is often desirable to make code modifications and re-deploy a stored procedure, UDF, or trigger. This is supported by the FairCom extension for the Visual Studio IDE.

Importing Existing Code

It is possible to retrieve existing stored procedure source code located on the server but not in the project/solution. The Import from Server option is used to accomplish this. If the stored procedure was deployed with source code, this option retrieves that code and adds it to the current project to allow modification.

Altering Properties

By right-clicking on a stored procedure module in Solution Explorer and selecting c‑tree Properties it is also possible to alter stored procedure parameters, result set, name and owner.