/// <summary> /// add a single game entry /// </summary> /// <param name="game"></param> public static void AddGame(MOBY_Game game) { using (var aG = new AsniScrapeAdminDbContext()) { aG.MOBY_Game.Add(game); aG.SaveChanges(); aG.Dispose(); } }
/// <summary> /// update a single game entry /// </summary> /// <param name="game"></param> public static void UpdateGame(MOBY_Game game) { using (var uG = new AsniScrapeAdminDbContext()) { uG.MOBY_Game.Update(game); uG.SaveChanges(); uG.Dispose(); } }
public static void UpdateDoc(Game_Doc doc) { using (var aG = new AsniScrapeAdminDbContext()) { // check whether doc url already exists Game_Doc doc1 = (from a in aG.Game_Doc.AsNoTracking() where a.id == doc.id select a).FirstOrDefault(); if (doc1 != null) { aG.Game_Doc.Update(doc); aG.SaveChanges(); aG.Dispose(); } } }
public static void AddDoc(Game_Doc doc) { using (var aG = new AsniScrapeAdminDbContext()) { // check whether doc url already exists List <Game_Doc> docs = (from a in aG.Game_Doc where a.downloadUrl == doc.downloadUrl select a).ToList(); if (docs.Count == 0) { aG.Game_Doc.Add(doc); aG.SaveChanges(); aG.Dispose(); } } }