//Ctor public SEORepository(DbContext _DbContext, string _TableName = "") { this.TableName = _TableName; if (_DbContext == null) throw new ArgumentNullException("DbContext"); DbContext = _DbContext; DbSet = _DbContext.Set<SEO>(); }
/// <summary> /// Create News Media Content /// </summary> /// <param name="newsMedia">newsMedia</param> /// <returns>Returns the news media content</returns> public NewsMedia Create(NewsMedia newsMedia) { using(var database = new DbContext(CONNECTION_NAME)) { database.Set<NewsMedia>().Add(newsMedia); database.SaveChanges(); return newsMedia; } }
/// <summary> /// Gets the list of News Media /// </summary> /// <param name="date">created date.</param> /// <returns>Returns the list of List<NewsMedia>.</returns> public List<NewsMedia> Select(DateTime date) { using (var database = new DbContext(CONNECTION_NAME)) { IQueryable<NewsMedia> query = database.Set<NewsMedia>(); query = AppendFilters(query,date); return query.ToList(); } }