public void DeleteDB() { try { using (DictionContext db = new DictionContext()) { var listAtDb = db.Dict.ToList(); db.Dict.RemoveRange(listAtDb); db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } }
public void LoadToDB(Dictionary <string, int> DictWords) { try { using (DictionContext db = new DictionContext()) { foreach (KeyValuePair <string, int> kvp in DictWords) { Diction row = new Diction { Word = kvp.Key, Repeat = kvp.Value }; db.Dict.Add(row); } db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } }