//GetCategoryMapById
        public CategoryMapDetail GetCategoryMapDetail(long id)
        {
            DataCacheObject   dco    = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETCATEGORYMAPDETAIL", new object[] { id }, CachingExpirationTime.Days_01);
            CategoryMapDetail result = CacheRepository.Get(dco) as CategoryMapDetail;

            if (result != null)
            {
                return(result);
            }
            result = (from p in dataContext.spCategoryMap_Detail(id)
                      select new CategoryMapDetail
            {
                Category_ID = p.Category_ID,
                CategoryDescription = p.CategoryDescription,
                CategoryMap_ID = p.CategoryMap_ID,
                CategoryTitle = p.CategoryTitle
            }).FirstOrDefault();
            if (result != null)
            {
                dco.Data = result;
                CacheRepository.Add(dco);
            }
            return(result);
        }