C# developers

Overview for using FairCom products as a C# developer

Installation and error codes

The General information section provides information that applies to all products.

Section	Description
Install FairCom products	Quick and advanced installation guides.
Error codes	Complete list of FairCom error codes.

JSON APIs for C#

FairCom's JSON DB APIis optimized for easy management of all data processing for microservices and n-tier applications.

Section	Description
JSON DB concepts	Guide for using the JSON DB API.
JSON DB API	Reference guide to use the JSON DB API.
jsonAction API	Core JSON API pattern that is used in FairCom APIs.

SQL for C#

FairCom’s SQL engine is ANSI-standard. It makes it easy and fast to modify and query data.

Section	Description
ODBC quick start	Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB.
ADO.NET API	Guide for using SQL with FairCom DB.
SQL reference	Language elements that are common to many FairCom DBSQL statements.
Full text search	Guide for using the full text search.
C# stored procedures	Tutorial for using the C# to implement SQL stored procedures in FairCom DB.
SQL stored procedures	Guide for using Java and C# to implement SQL stored procedures and triggers.
ISQL tutorial	Tutorials for using FairCom's interactive SQL command line utility (iSQL).
ISQL CLI	Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
SQL operations	Advanced FairCom SQL features, options, and utilities.
SQL error codes	Complete list of SQL error codes.

Record Buffer APIs for C#

FairCom provides advanced APIs that control all aspects of data processing. They allow you to build solutions that are unrivaled in capability and performance because they allow your code to directly control all aspects of the FairCom DBengine. These APIs retrieve record buffers from disk or cache and directly load them into application memory. This approach is exceptionally fast and works best for applications that run on the same computer as the FairCom DB server.

Section	Description
C# CTDB tutorial	Tutorials for working with record buffers using the JTDB API.
C# CTDB API	Guide for using the c-treeDB API in C#.
Full text search	Guide for using the full text search.

Summary of JSON APIs for C# Developers Using FairCom FairCom's JSON DB API is designed for managing microservices and n-tier applications, ensuring seamless data processing and integration. JSON API Overview: JSON DB Concepts – Guide to using the JSON DB API. JSON DB API Reference – Comprehensive documentation for working with JSON-based database operations. jsonAction API – Core API pattern for managing data across FairCom products. JSON DB API Tutorial – Originally for Java, but useful for understanding JSON database interactions. SQL for C# Developers: FairCom’s SQL engine follows ANSI standards, simplifying data modification and querying. ODBC Quick Start – Tutorials for using FairCom’s ODBC driver on Windows and Linux. ADO.NET API – Guide to integrating FairCom DB SQL with C#. SQL Reference & Operations – Best practices for SQL language elements, utilities, and optimizations. Stored Procedures – Tutorials for implementing C#-based SQL procedures and triggers. ISQL Tutorial & CLI – Guides for using FairCom’s SQL command-line utility. Full-Text Search – Instructions for advanced text search capabilities. Record Buffer APIs for C# Developers: FairCom offers low-level control over data processing with Record Buffer APIs, optimized for high-speed retrieval. C# CTDB Tutorial – Guide to working with record buffers. C# CTDB API – Reference for using FairCom’s c-treeDB API. Full-Text Search – Search capabilities across structured data.

JSON DB API: Microservices, n-tier applications, structured queries, schema-less data handling jsonAction API: Core API pattern for managing database operations SQL for C#: ADO.NET, ODBC, SQL queries, stored procedures, triggers Database Management: FairCom DB, indexing, full-text search, SQL optimization Record Buffer APIs: Low-level data control, CTDB API, high-performance data retrieval Installation & Troubleshooting: FairCom installation guides, SQL error codes, performance tuning