I have an - IDbConnection - sql = @"UPDATE tablename SET json = :json, lastupdate = SYSDATE WHERE id = :id"
var param = new DynamicParameters(); param.Add(":json", json, DbType.AnsiString); param.Add(":id", currentTemplate.Id); if (connection == null || connection.State != ConnectionState.Open) continue; connection.Execute(sql, param); // hangs here. connection.Query(sql, param); // tried this and this also hangs.
Coding stops at connection.Execute. No error or anything. Just hangs.
:json is a serialized object returned by JsonConvert.
:id is a string
I've also tried removing the parameters and including the values in the SQL itself.