/// <summary> /// Execute a command that returns multiple result sets, and access each in turn. /// </summary> /// <param name="db">The DB to query on.</param> /// <param name="sql">The SQL to execute for this query.</param> /// <param name="param">The parameters to use for this query.</param> /// <param name="commandTimeout">Number of seconds before command execution timeout.</param> /// <param name="commandType">Is it a stored proc or a batch?</param> public static GridReader QueryMultiple(this Db db, string sql, object param = null, int?commandTimeout = null, CommandType?commandType = null) { var command = new CommandDefinition(sql, param, db.Transaction, commandTimeout, commandType, CommandFlags.Buffered); return(SqlMapper.QueryMultipleImpl(db.Connection, ref command)); }
/// <summary> /// Execute a command that returns multiple result sets, and access each in turn. /// </summary> /// <param name="db">The DB to query on.</param> /// <param name="command">The command to execute for this query.</param> public static GridReader QueryMultiple(this Db db, CommandDefinition command) => SqlMapper.QueryMultipleImpl(db.Connection, ref command);