Reputation: 235
I have been trying to determine what cache is being used when you call SqlHelperParameterCache.GetSpParameterSet. I think it may be the SQL SErver Execution plan cache but I am not sure: https://msdn.microsoft.com/en-us/library/ms175580.aspx
I can't seem to find a definitive answer on MSDN. Any ideas about this ancient object?
Thanks!
Upvotes: 2
Views: 300
Reputation: 33853
Based off of this source code that looks to be a mirror the original, it would appear that they are using a static Hashtable
. The cache wouldn't live beyond the AppPool lifecycle as a result.
private static Hashtable paramCache = Hashtable.Synchronized(new Hashtable());
Upvotes: 1