Dapper Hangs at Execute

c# dapper database idbconnection json

Question

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.

Popular Answer

In my case, I had an uncommitted transaction in another session, as described here: Oracle Update Hangs



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why