public static List <QuestionEntity> GetQuestionList()
{
List <QuestionEntity> list = new List <QuestionEntity>();
Cache cache = HttpRuntime.Cache;
if (cache["Keys"] == null)
{
string sql = string.Format(@"SELECT ID,
[Question]
,[OptionA]
,[OptionB]
,[OptionC]
,[OptionD]
,[Answer]
,[Type]
,[Multi]
FROM [WaterSupplySecurity].[dbo].[QuestionBank]");
list = DataAcccessHelper.Query <QuestionEntity>(sql).ToList();
cache.Insert("Keys", list);
}
{
list = cache["Keys"] as List <QuestionEntity>;
}
return(list);
}
