Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

.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

TOCIndex