public int ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = MyDatabase.CreateCommand(); using (DbConnection conn = MyDatabase.CreateConnection()) { conn.ConnectionString = MyDatabase.GetConnection(); PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(val); } }