Dapper hangs on execution
I have - 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.
Encoding stops when connected. Performance. There is no mistake or anything else. It just hangs.
: json is the serialized object returned by JsonConvert.
: id - string
I also tried removing the parameters and including the values ββin the SQL itself.
+2
source to share
1 answer
In my case, I had an uncommitted transaction in another session as described here: Oracle Update Hangs
+1
source to share