private static void AddIdentificationList(QueryBuilder queryBuilder, CacheKey result) { result.IdentificationList = new List <string>(); result.IdentificationList.Add(queryBuilder.GetTableNameString); result.IdentificationList.Add(queryBuilder.GetJoinValueString); result.IdentificationList.Add(queryBuilder.GetOrderByString); result.IdentificationList.Add(queryBuilder.GetGroupByString); result.IdentificationList.Add(queryBuilder.GetWhereValueString); result.IdentificationList.Add(queryBuilder.PartitionByValue); result.IdentificationList.Add(queryBuilder.Take.ObjToString()); result.IdentificationList.Add(queryBuilder.Skip.ObjToString()); result.IdentificationList.Add(queryBuilder.IsCount.ObjToString()); result.IdentificationList.Add(UtilMethods.GetMD5(queryBuilder.GetSelectValue.ObjToString())); if (queryBuilder.Parameters.HasValue()) { foreach (var item in queryBuilder.Parameters) { result.IdentificationList.Add(item.ParameterName + "_" + item.Value); } } }