To write a .NET stored procedure (SP), user-defined function (UDF), or trigger, a new project must be created using one of the supplied templates (see Visual Studio .NET Development). The steps below will create a C# stored procedure project.
Tutorials, which follow the format of the standard FairCom tutorials, are provided in drivers\<Your-API-Folder>\tutorials\.
Note: The extension for Visual Studio must be installed before you can perform the procedures in this section. See Visual Studio .NET Development.
Open Visual Studio.
Create a new project and, from the templates, select Visual C# > c-tree > Stored Procedure, Trigger and UDF.
Set the project name and location and click OK.
From the resulting dialog, pick the Data Source (pre-configured in Visual Studio) or Custom and provide the necessary server connection information (the server does not need to be running).
A new Solution and a new project will be created and opened. In Solution Explorer, you should see one folder for each type of project: Stored Procedures, Triggers, and UDFs.
