/// <summary> /// Executes the CommandText against the Connection and builds an IDataReader. /// </summary> /// <param name="command">The command.</param> /// <returns>An IDataReader object.</returns> public virtual IDataReader ExecuteReader(APSqlCommand command) { DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return(dbCmd.ExecuteReader()); }
/// <summary> /// Executes an SQL statement against the Connection and returns the number of rows affected. /// </summary> /// <param name="command">The command.</param> /// <returns>The number of rows affected.</returns> public virtual int ExecuteNonQuery(APSqlCommand command) { DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return(dbCmd.ExecuteNonQuery()); }
/// <summary> /// Executes the query, and returns the first column of the first row in the result set returned /// by the query. Additional columns or rows are ignored. /// </summary> /// <param name="command">The command.</param> /// <returns>The first column of the first row in the result set, or a null reference if the result set is empty.</returns> public virtual object ExecuteScalar(APSqlCommand command) { if (command is APSqlInsertCommand) { (command as APSqlInsertCommand).NeedReturnAutoIncrement = true; } DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return(dbCmd.ExecuteScalar()); }
/// <summary> /// Build command. /// </summary> /// <param name="command">The command.</param> /// <returns>The DbCommand.</returns> public DbCommand BuildCommand(APSqlCommand command) { if (command is APSqlSelectCommand) { return(BuildSelectCommand(command as APSqlSelectCommand)); } else if (command is APSqlDeleteCommand) { return(BuildDeleteCommand(command as APSqlDeleteCommand)); } else if (command is APSqlUpdateCommand) { return(BuildUpdateCommand(command as APSqlUpdateCommand)); } else if (command is APSqlInsertCommand) { return(BuildInsertCommand(command as APSqlInsertCommand)); } else { throw new APDataException(APResource.APData_UnknownQueryCommand); } }
/// <summary> /// Build condition phrase of 'NOT IN'. /// </summary> /// <param name="subQuery">Sub query.</param> /// <returns>Condition phrase of 'NOT IN'.</returns> public APSqlConditionPhrase NotIn(APSqlCommand subQuery) { return(new APSqlConditionPhrase(this, APSqlConditionOperator.NotIn, subQuery)); }
/// <summary> /// Build condition phrase of 'NOT IN'. /// </summary> /// <param name="subQuery">Sub query.</param> /// <returns>Condition phrase of 'NOT IN'.</returns> public APSqlConditionPhrase NotIn(APSqlCommand subQuery) { return new APSqlConditionPhrase(this, APSqlConditionOperator.NotIn, subQuery); }
/// <summary> /// Executes the CommandText against the Connection and builds an IDataReader. /// </summary> /// <param name="command">The command.</param> /// <returns>An IDataReader object.</returns> protected IDataReader ExecuteReader(APSqlCommand command) { return(_database.ExecuteReader(command)); }
/// <summary> /// Convert return value of ExecuteScalar to int type. /// </summary> /// <param name="command">The command.</param> /// <returns>The count of query execute.</returns> protected int ExecuteCount(APSqlCommand command) { return(Convert.ToInt32(ExecuteScalar(command))); }
/// <summary> /// Executes the query, and returns the first column of the first row in the result set /// returned by the query. Additional columns or rows are ignored. /// </summary> /// <param name="command">The command.</param> /// <returns>The first column of the first row in the result set, or a null reference if /// the result set is empty.</returns> protected object ExecuteScalar(APSqlCommand command) { return(_database.ExecuteScalar(command)); }
/// <summary> /// Executes an SQL statement against the Connection and returns the number of rows affected. /// </summary> /// <param name="command">The command.</param> /// <returns>The number of rows affected.</returns> protected int ExecuteNonQuery(APSqlCommand command) { return(_database.ExecuteNonQuery(command)); }
/// <summary> /// Executes the CommandText against the Connection and builds an IDataReader. /// </summary> /// <param name="command">The command.</param> /// <returns>An IDataReader object.</returns> public virtual IDataReader ExecuteReader(APSqlCommand command) { DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return dbCmd.ExecuteReader(); }
/// <summary> /// Executes the query, and returns the first column of the first row in the result set returned /// by the query. Additional columns or rows are ignored. /// </summary> /// <param name="command">The command.</param> /// <returns>The first column of the first row in the result set, or a null reference if the result set is empty.</returns> public virtual object ExecuteScalar(APSqlCommand command) { if (command is APSqlInsertCommand) (command as APSqlInsertCommand).NeedReturnAutoIncrement = true; DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return dbCmd.ExecuteScalar(); }
/// <summary> /// Executes an SQL statement against the Connection and returns the number of rows affected. /// </summary> /// <param name="command">The command.</param> /// <returns>The number of rows affected.</returns> public virtual int ExecuteNonQuery(APSqlCommand command) { DbCommand dbCmd = _provider.BuildCommand(command); dbCmd.Connection = Connection; dbCmd.Transaction = _transaction; return dbCmd.ExecuteNonQuery(); }
/// <summary> /// Build command. /// </summary> /// <param name="command">The command.</param> /// <returns>The DbCommand.</returns> public DbCommand BuildCommand(APSqlCommand command) { if (command is APSqlSelectCommand) return BuildSelectCommand(command as APSqlSelectCommand); else if (command is APSqlDeleteCommand) return BuildDeleteCommand(command as APSqlDeleteCommand); else if (command is APSqlUpdateCommand) return BuildUpdateCommand(command as APSqlUpdateCommand); else if (command is APSqlInsertCommand) return BuildInsertCommand(command as APSqlInsertCommand); else throw new APDataException(APResource.APData_UnknownQueryCommand); }