Dremio C# example using flight sql odbc driver

Program.cs

using System;
using System.Data.Odbc;

class Program
{
    static void Main()
    {
        string connectionString = "DRIVER={Arrow Flight SQL ODBC Driver};host=localhost;UID=dremio;PWD=dremio123;PORT=32010;UseEncryption=false;DisableHostVerification=1;DisableCertificateVerification=1;HandshakeTimeout=100;ROUTING_TAG=testing";
        using (OdbcConnection connection = new OdbcConnection(connectionString))
        {
            try
            {
                connection.Open();
                string query = "SELECT name,kind FROM sys.options limit 10"; 
                using (OdbcCommand command = new OdbcCommand(query, connection))
                {
                    command.CommandTimeout = 50;
                    //https://learn.microsoft.com/en-us/dotnet/api/system.data.odbc.odbccommand.commandtimeout?view=dotnet-plat-ext-8.0#property-value
                    using (OdbcDataReader reader = command.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                Console.WriteLine($"Name: {reader["name"]}, Kind: {reader["kind"]}");
                            }
                        }
                        else
                        {
                            Console.WriteLine("No rows found.");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error: {ex.Message}");
            }
        }
    }
}

1. Create a new project and run the following in the solution folder:

dotnet add package System.Data.Odbc --version 4.8.3

2. Install Dremio Flight ODBC Driver: https://www.dremio.com/drivers/odbc/
3. Run the above program