public void PGCmd(PgSqlConnection conn, string insertStr) { conn.Open(); PgSqlTransaction tx = conn.BeginTransaction(IsolationLevel.ReadCommitted); cmdPG.Connection = connPG; cmdPG.CommandText = insertStr; // PgSqlParameter parm = cmd.CreateParameter(); //parm.ParameterName = "@name"; //parm.Value = "SomeName"; //cmd.Parameters.Add(parm); cmdPG.Prepare(); try { cmdPG.ExecuteScalar(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex); } tx.Commit(); conn.Close(); }