/// <summary> /// return data context with attached debugger /// </summary> private static DataClassesNewsDataContext getNewsDataContext() { DataClassesNewsDataContext db = new DataClassesNewsDataContext(); db.Log = new DebuggerWriter(); return(db); }
public static IEnumerable <NEWS_ITEM> GetNews() { DataClassesNewsDataContext db = new DataClassesNewsDataContext(); IEnumerable <NEWS_ITEM> data = db.NEWS_ITEMs.OrderBy(e => e.TimeStamp); return(data); }
/// <summary> /// Gets News, ordered by DateTime /// </summary> /// <returns></returns> private static IEnumerable <NewsItem> GetNewsHelper(string cultureCode, bool isTopNews) { DataClassesNewsDataContext db = getNewsDataContext(); return(from val in db.NewsValues join key in db.NewsKeys on val.NewsKeyID equals key.NewsKeyID where val.CultureCode == cultureCode && key.TopNewsIndicator == isTopNews && key.Visible == true orderby key.NewsDate descending select new NewsItem() { ContentText = val.BodyText, CultureCode = val.CultureCode, NewsDate = key.NewsDate, NewsId = key.NewsKeyID, TitleText = val.HeaderText, TopNews = key.TopNewsIndicator }); }