C#直接插入sql正常，参数化插入报错code: [0x216],error: Syntax error in SQL

应用开发者专区
1 
        //    CREATE TABLE IF NOT EXISTS sensors (
        //        ts TIMESTAMP,
        //        device_id BINARY(20),
        //        value1 FLOAT
        //    )

        using var conn = new TDengineConnection("host=localhost;port=6030;username=root;password=taosdata;db=demo");
        conn.Open();

        string deviceId = "dev_001";
        float value = 23.5f;
        string sql = $"INSERT INTO sensors VALUES (now, '{deviceId}', {value})";
        new TDengineCommand(conn) { CommandText = sql }.ExecuteNonQuery();

        string paramSql = "INSERT INTO sensors VALUES ($ts, $device, $value1)";
        using var cmd = new TDengineCommand(conn) { CommandText = paramSql };
        cmd.Parameters.Add(new TDengineParameter { ParameterName = "$ts", Value = DateTime.Now });
        cmd.Parameters.Add(new TDengineParameter { ParameterName = "$device", Value = "dev_002" });
        cmd.Parameters.Add(new TDengineParameter { ParameterName = "$value1", Value = 24.0f });
        cmd.ExecuteNonQuery();
TDengine.Driver.TDengineError:“code: [0x216],error: Syntax error in SQL”
2

麻烦提供数据库版本信息，驱动版本信息。

3

需具体信息，如遇相同问题，请重新发帖。