Alternate method to SqlHelperParameterCache.GetSpParameterSet

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

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. http://cs-dotnetnuke.googlecode.com/svn/trunk/CS_Library/Components/ApplicationBlocks/SQLHelper.cs).

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
entlib.support@live.com
Enterprise Library support engineer
Support How-to