[Question] But how can I pass parameters?

[darkwanderer]

[Question] But how can I pass parameters?

[DarkWanderer]

Hi, passing parameters is something I had half-ready but forgot to finalize. I'll add it to next release

The syntax is as follows:

            using var command = connection.CreateCommand();
            command.CommandText = "SELECT {id:Int32}, {str:String}, {tuple:Tuple(UInt8, String)}";
            
            command.AddParameter("id", 906324);
            command.AddParameter("str", "Any string, even with some unicode");
            command.AddParameter("tuple", "(10, 'str')");

            var result = await command.ExecuteReaderAsync();

This uses ClickHouse's parameters syntax

AddParameter is an extension to do command.AddParameter(); parameter.Value = ... etc.

[t-smirnov]

Oh, nice, thanks @DarkWanderer