Stored procedure parameter discovery caching

Topics: Data Access Application Block, Pre-release discussions
Mar 1, 2007 at 8:40 AM
I am wondering why only Database.GetStoredProcCommand(string storedProcedureName, params object[] parameterValues) uses stored procedure parameter cache when discovering parameters.

There are two methods that would also benefit from parameter caching:
- Database.GetStoredProcCommand(string storedProcedureName)
- Database.GetStoredProcCommandWithSourceColumns(string storedProcedureName, params string[] sourceColumns)

Is there a good reason for this?

I have been using Enterprise Library 2.0 for a while now and I was hoping this would be fixed for the next release.
May 27, 2007 at 7:42 AM
I am currently working to make this into a complete block, but you may still find it usefull

let me know if you find it usefull