DataAccessBase.ExecuteStoredProcedureReader<T>

Calls a stored procedure that returns a cursor results The result is returned as an IEnumerable> list

public virtual IEnumerable<T> ExecuteStoredProcedureReader<T>(string storedProc,
	Object[] parameters)

Return Value

A DataReader or null on failure

Parameters

storedProc
Name of the Stored Procedure to call

parameters
Use CreateParameter() for named, output or return parameters. Plain values for others.

Example

IEnumerable<Customer%gt; customers = context.Db.ExecuteStoredProcedureReader<Customer>('GetCustomers',
             context.Db.CreateParameter('@cCompany','W%'));

See also:

Class DataAccessBase
© West Wind Technologies, 1996-2023 • Updated: 07/15/20
Comment or report problem with topic