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, 2019 • Updated: 06/23/19
Comment or report problem with topic