Alternate method to SqlHelperParameterCache.GetSpParameterSet

Topics: Building and extending application blocks
Nov 12, 2013 at 9:45 AM

I am removing ApplicationBlock from my project. I need to find out any alternate method for- SqlHelperParameterCache.GetSpParameterSet of Microsoft.ApplicationBlock which cab be implement by Enterprise library.

please assist.
Nov 14, 2013 at 1:34 AM
Are you using the old SqlHelper? If that is the case then you can see the code around (e.g.

The idea is to call SqlCommandBuilder.DeriveParameters to retrieve the parameters, clone the parameters and then cache the IDataParameter[] (the original code uses a Hashtable).

This functionality is still available out of the box in Enterprise Library.

Randy Levy
Enterprise Library support engineer
Support How-to