internal string GetCacheKey(string spName, DataSet procData)
{
string retValue = String.Empty;
StringBuilder key = new StringBuilder(spName);
key.Append("(");
string delimiter = "";
if (procData.Tables.Contains("Procedure Parameters"))
{
foreach (DataRow row in procData.Tables["Procedure Parameters"].Rows)
{
if (row["ORDINAL_POSITION"].Equals(0))
retValue = "?=";
else
{
key.AppendFormat(CultureInfo.InvariantCulture, "{0}?", delimiter);
delimiter = ",";
}
}
}
key.Append(")");
return retValue + key.ToString();
}