C# (CSharp) DAL SqlHelperParameterCache Examples

Example #1

 public static SqlParameter[] GetSpParameterSet(string connectionString, string spName)
 {
     return(SqlHelperParameterCache.GetSpParameterSet(connectionString, spName, false));
 }

Example #2

File: SqlHelperParameterCache.cs Project: SkelletonX/DDTServer

        public static SqlParameter[] GetSpParameterSet(string connectionString, string spName, bool includeReturnValueParameter)
        {
            string hashKey = connectionString + ":" + spName + (includeReturnValueParameter ? ":include ReturnValue Parameter" : "");

            SqlParameter[] cachedParameters = (SqlParameter[])SqlHelperParameterCache.paramCache[hashKey];
            if (cachedParameters == null)
            {
                cachedParameters = (SqlParameter[])(SqlHelperParameterCache.paramCache[hashKey] = SqlHelperParameterCache.DiscoverSpParameterSet(connectionString, spName, includeReturnValueParameter));
            }
            return(SqlHelperParameterCache.CloneParameters(cachedParameters));
        }