public SW_Lang GetLang(string langShortName) { HttpContext c = HttpContext.Current; SW_Lang getLang = (SW_Lang)c.Cache["getlang-" + langShortName]; if (getLang == null) { Searchwar_netEntities db = new Searchwar_netEntities(); getLang = (from L in db.SW_Lang where L.LangShortname.ToLower() == langShortName select L).SingleOrDefault <SW_Lang>(); // add Cache c.Cache.Add("getlang-" + langShortName, getLang, null, TimeZoneManager.DateTimeNow.AddMonths(1), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null); } return(getLang); }
public SW_Lang GetLang(int langaugeId) { using (Searchwar_netEntities db = new Searchwar_netEntities()) { SW_Lang Result = (from L in db.SW_Lang where L.LangId.Equals(langaugeId) select L).SingleOrDefault <SW_Lang>(); return(Result); } }