FireboltNetSDK 0.0.1

firebolt-net-sdk

This is an implementation of .NET Core driver(.NET 6) for Firebolt DB in a form of ADO.NET DbProvider API. Supports all latest .NET frameworks and all platforms.

This project is developed under Visual Studio 2022. Earlier versions of Visual Studio are not supported.

Installing the Package

Packages can be directly downloaded from nuget.org.

It can also be downloaded using Visual Studio UI (Tools > NuGet Package Manager > Manage NuGet Packages for Solution and search for "Firebolt")

Alternatively, packages can also be downloaded using Package Manager Console:

PM> Install-Package Firebolt

Examples

The following example demonstrates how to open a connection to Firebolt

            string database = "****";
            var username = "****";
            var password = "****";
            string endpoint = "****";
            string account = "firebolt";
            string engine = "****";
            string conn_string = $"database={database};username={username};password={password};endpoint={endpoint};account={account}";
          
            using var conn = new FireboltConnection(conn_string);
           
            conn.Open();

            conn.Close();

Connect and set specific engine if empty will take default

    
            string conn_string = $"database={database};username={username};password={password};endpoint={endpoint};";
          
            using var conn = new FireboltConnection(conn_string);
           
            conn.Open();

            conn.SetEngine(engine);

            conn.Close();

Execute command

            var connString = $"database={_database};username={_username};password={_password};endpoint={_endpoint};";

            using var conn = new FireboltConnection(connString);
            conn.Open();

            var cursor = conn.CreateCursor();

            cursor.Execute("SELECT 1");

            conn.Close();

Execute command with SET parameter

            var connString = $"database={_database};username={_username};password={_password};endpoint={_endpoint};account={_account}";

            using var conn = new FireboltConnection(connString);
            conn.Open();

            var cursor = conn.CreateCursor();
            cursor.Execute("SET use_standard_sql=0");

            cursor.Execute("SELECT 1");

            conn.Close();