public void AddRange(ICollection <Link> links) { using (LinksDbContext db = container.GetInstance <LinksDbContext>()) { db.Links.AddRange(links); db.SaveChanges(); } }
public bool Contains(string url) { Link args = null; using (LinksDbContext db = container.GetInstance <LinksDbContext>()) args = db.Links.Where(link => link.Url == url).FirstOrDefault(); if (args == null) { return(false); } return(true); }
public void CheckAddSave(Link link) { using (LinksDbContext db = container.GetInstance <LinksDbContext>()) { var args = db.Links.Where(item => item.Url == link.Url).FirstOrDefault(); if (args != null) { return; } db.Links.Add(link); db.SaveChanges(); } }
public void RemoveDuplicate() { using (LinksDbContext db = container.GetInstance <LinksDbContext>()) { var duplicates = db.Links.GroupBy(link => link.Url) .Where(g => g.Count() > 1) .Select(y => y.Key) .ToList(); foreach (var dup in duplicates) { var link = db.Links.Where(li => li.Url == dup).First(); db.Links.Remove(link); } db.SaveChanges(); } }
public HomeController(ILogger <HomeController> logger, LinksDbContext context, HttpGetClass getClass) { _logger = logger; _context = context; _getClass = getClass; }
public LinksRepository(LinksDbContext context) { _context = context; }
public void SaveChanges() { using (LinksDbContext db = container.GetInstance <LinksDbContext>()) db.SaveChanges(); }
public ICollection <string> GetAllWithIteration(int iteration) { using (LinksDbContext db = container.GetInstance <LinksDbContext>()) return(db.Links.Where(link => link.IterationId == iteration).Select(link => link.Url).ToList()); }