Quick start

using System;
using System.Threading.Tasks;
using ClickHouse.Client.ADO;
using ClickHouse.Client.Utility;

namespace Clickhouse.Test;
class Program
{
    static async Task Main(string[] args)
    {
        using var connection = new ClickHouseConnection("Host=my.clickhouse;Protocol=https;Port=12345;Username=user");
        // ExecuteScalarAsync is an async extension which creates command and executes it
        var version = await connection.ExecuteScalarAsync("SELECT version()");
        Console.WriteLine(version);
    }
}

using System;
using System.Threading.Tasks;
using ClickHouse.Client.ADO;
using Dapper;

namespace Clickhouse.Test;

class Program
{
    static async Task Main(string[] args)
    {
        using var connection = new ClickHouseConnection("Host=my.clickhouse");
        string sql = "SELECT * FROM system.table_functions";
        var functions = await connection.QueryAsync<string>(sql);
        Console.WriteLine(string.Join('\n', functions));
    }
}