コード例 #1
0
        public override IDataReader ExecuteReader(string commandText, params DbParam [] parameters)
        {
            MySqlConnection        conn    = null;
            MySqlCommand           command = null;
            MySQLDataReaderWrapper dr      = null;
            DateTime start      = DateTime.Now;
            bool     isReadOnly = false;

            try {
                command = GetCommand(out conn, commandText, parameters, out isReadOnly);
                if (command == null)
                {
                    return(null);
                }

                //create a reader and use a stupid retry as sometimes the server kills the query for no good reason
                IDataReader reader = command.ExecuteReader() ?? command.ExecuteReader() ?? command.ExecuteReader();
                if (reader == null)
                {
                    throw new DbConnectionLostException("Could not get a valid reader from the database");
                }

                dr           = new MySQLDataReaderWrapper(conn, TransactionContext.Current, reader, command);
                dr.Disposed += DataReader_Disposed;

                // detach the SqlParameters from the command object, so they can be used again.
                command.Parameters.Clear();
            } catch (MySqlException ex) {
                CleanupReaderOnError(dr, conn, command);
                if (ex.HasException <SocketException> () ||
                    ex.HasException <TargetInvocationException> () ||
                    ex.HasException <TimeoutException> ())
                {
                    throw new DbConnectionLostException(ex);
                }

                throw new Exception("MySql", ex);
            } catch (DbConnectionLostException) {
                CleanupReaderOnError(dr, conn, command);
                throw;
            } catch {
                CleanupReaderOnError(dr, conn, command);
            } finally {
                OnCommandExecuted(commandText, start, parameters, isReadOnly);
            }

            return(dr);
        }
コード例 #2
0
        private void CleanupReaderOnError(MySQLDataReaderWrapper dr, MySqlConnection conn, MySqlCommand command)
        {
            TransactionContext context = TransactionContext.Current;

            if (dr != null && !dr.IsDisposed)
            {
                DataReader_Disposed(dr, new DataReaderDisposedEventArgs(conn, context, command));
                return;
            }

            if (command != null && context != null)
            {
                context.ReleaseConnection();
            }

            if (command != null)
            {
                command.Dispose();
            }
        }