protected virtual ResultResource ExecuteCommandInternal(string /*!*/ commandText, CommandType commandType, bool convertTypes, IEnumerable <IDataParameter> parameters, bool skipResults) { ClosePendingReader(); // IDbCommand IDbCommand command = CreateCommand(commandText, commandType); if (parameters != null) { command.Parameters.Clear(); foreach (IDataParameter parameter in parameters) { command.Parameters.Add(parameter); } } // ExecuteReader ResultResource result = null; try { var /*!*/ reader = _pendingReader = command.ExecuteReader(); if (skipResults) { // reads all data: do { while (reader.Read()) { ; } } while (reader.NextResult()); } else { _lastResult = null; // read all data into PhpDbResult: result = GetResult(this, reader, convertTypes); result.command = command; _lastResult = result; } _lastException = null; } catch (Exception e) { _lastException = e; PhpException.Throw(PhpError.Warning, LibResources.command_execution_failed, GetExceptionMessage(e)); } // return(result); }
protected virtual ResultResource ExecuteCommandProtected(IDbCommand command, bool convertTypes, IList <IDataParameter> parameters, bool skipResults) { if (parameters != null) { command.Parameters.Clear(); for (int iparam = 0; iparam < parameters.Count; iparam++) { command.Parameters.Add(parameters[iparam]); } } // ExecuteReader ResultResource result = null; try { var /*!*/ reader = _pendingReader = command.ExecuteReader(); if (skipResults) { // reads all data: do { while (reader.Read()) { ; } } while (reader.NextResult()); } else { _lastResult = null; // read all data into PhpDbResult: result = GetResult(reader, convertTypes); result.command = command; _lastResult = result; } _lastException = null; } catch (Exception e) { _lastException = e; PhpException.Throw(PhpError.Warning, LibResources.command_execution_failed, GetExceptionMessage(e)); } // return(result); }
/// <summary> /// Reexecutes a command associated with a specified result resource to get schema of the command result. /// </summary> /// <param name="result">The result resource.</param> internal void ReexecuteSchemaQuery(ResultResource /*!*/ result) { if (!Connect() || result.Command == null) { return; } ClosePendingReader(); try { result.Reader = _pendingReader = result.Command.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SchemaOnly); } catch (Exception e) { _lastException = e; PhpException.Throw(PhpError.Warning, LibResources.command_execution_failed, GetExceptionMessage(e)); } }
/// <summary> /// Reexecutes a command associated with a specified result resource to get schema of the command result. /// </summary> /// <param name="result">The result resource.</param> internal void ReexecuteSchemaQuery(ResultResource /*!*/ result) { if (!Connect() || result.Command == null) { return; } ClosePendingReader(); try { result.Reader = _pendingReader = result.Command.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SchemaOnly); } catch (System.Exception e) { _lastException = e; throw new NotImplementedException(); // ERR //PhpException.Throw(PhpError.Warning, LibResources.GetString("command_execution_failed", // GetExceptionMessage(e))); } }