Aaron L.
Aaron L.

Reputation: 235

What "cache" is being used in sqlhelperparametercache

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

Answers (1)

David L
David L

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

Related Questions