Execute StoredProcedure without parameters using database accessors

Topics: Data Access Application Block
May 21, 2010 at 8:21 PM

 

I am using a database accessor to execute a stored procedure. But the stored procedure doesn't have parameters. How do I use the database.executesprocaccessor method without the paramArray parameter?

Thanks for your help!

 

May 24, 2010 at 12:33 AM

The params keyword means that a parameter is optional.  The parameterValues parameter in the ExecuteSprocAccessor is preceded by this keyword so you can call it just passing the name of the stored procedure.

 

Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.
entlib.support@avanade.com