public void ChangeDbIDList( string Name, string Data ) { IDList idlist = new IDList { Name = Name, Data = Data }; using (var db = new BlacklistDatabaseContext()) { db.IDList.Add(idlist); try { db.IDList.Add(idlist); db.SaveChanges(); } catch (SqliteException) { db.IDList.Update(idlist); db.SaveChanges(); } catch (DbUpdateException) { db.IDList.Update(idlist); db.SaveChanges(); } } }
public IDList GetIDList(string name) { IDList config = null; config = Config.IDList.GetValueOrDefault(name, null); if (config != null) { return(config); } using (var db = new BlacklistDatabaseContext()) { IDList idList; try { idList = db.IDList .Single(idLists => idLists.Name == name); Config.IDList.TryAdd(name, idList); } catch (InvalidOperationException) { idList = new IDList { Name = name, Data = "" }; db.IDList.Add(idList); Config.IDList.TryAdd(name, idList); db.SaveChanges(); return(idList); } return(idList); } }