/// <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);
