//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); }