Calling Stored Procedures that Return a DataReader

To run a stored procedure that returns a DataReader, use one of the ExecSprocReader methods.

  • Executes the specified stored procedure in the default database, returning a data reader with the result set.

    protected virtual IDataReader ExecSprocReader(string sprocName)
    

  • Executes the specified stored procedure in the specified database, returning a data reader with the result set.

    protected virtual IDataReader ExecSprocReader(string sprocName, string databaseKey)
    

  • Executes the specified stored procedure and parameters in the specified database, returning a data reader with the result set.

    protected virtual IDataReader ExecSprocReader(string sprocName, string databaseKey,
    	params IDbDataParameter[] dataParams)

© (c) 2026 Oak Leaf Enterprises, Inc., 1996-2026 • Updated: 07/28/18
Comment or report problem with topic