FairCom Java & .NET Stored Procedures

.NET Support

Microsoft .NET framework provides a common runtime functionality for Windows applications. This allows a consistent and comprehensive programming model for Windows developers. FairCom DB SQL now extends .NET support for our stored procedure programming framework which is a more suitable and native environment for Windows developers than our existing cross-platform Java framework.

Key features of this environment include:

• SP, UDF, and triggers can be written in any language that compiles to a CLI.
• SQL classes, similar to ADO, are exposed.
• SP, UDF, and triggers can be debugged by attaching to the server.
• Visual Studio 2012 and later are supported.

With this .NET support, you can use Visual Studio to create, edit, and debug your SP, UDF, and triggers. An API is provided along with a Visual Studio extension for complete .NET development. You can compile on the client and deploy binaries to the server.

Tutorials, which follow the format of the standard FairCom tutorials, are provided. See .NET Tutorials (in this book) and see the ReadMe titled FairCom C# Stored Procedures.

In This Chapter Visual Studio .NET Development .NET Tutorials Mapping Between SQL Types and .NET Types The .NET Ctree.SqlSP Assembly