private static void SetCachedResult(SqlCommand command, object value)
{
if (command.CommandType == CommandType.StoredProcedure && StoredProceduresToCache.ContainsKey(command.CommandText))
{
_cachedStoredProcedureResults[command] = new CachedResult
{
TimeAdded = DateTime.Now,
Value = value
};
}
}
private static object GetCachedResult(SqlCommand command)
{
if (command.CommandType == CommandType.StoredProcedure && StoredProceduresToCache.ContainsKey(command.CommandText))
{
CachedResult cachedResult;
if (_cachedStoredProcedureResults.TryGetValue(command, out cachedResult))
{
if (DateTime.Now.Subtract(cachedResult.TimeAdded) < StoredProceduresToCache[command.CommandText])
{
return(cachedResult.Value);
}
else
{
_cachedStoredProcedureResults.Remove(command);
}
}
}
return(null);
}