public void GivenInitialDataset() { using (var ctx = new GlossaryEntities()) { if (ctx.Definitions.Any()) { var defs = from d in ctx.Definitions select d; ctx.Definitions.RemoveRange(defs); } ctx.Definitions.AddRange( new Definition[] { new Definition { Term = "abyssal plain", TermDefinition = "The ocean floor off the continental margin, usually very flat with a slight slope." }, new Definition { Term = "accrete", TermDefinition = "To add terranes (small land masses or pieces of crust) to another, usually larger, land mass." }, new Definition { Term = "alkaline", TermDefinition = "Term pertaining to highly basic, as opposed to acidic, substance" } }); ctx.SaveChanges(); } }
public void ListDefinitions() { using (var ctx = new GlossaryEntities()) { var defs = (from d in ctx.Definitions select d).ToList(); defs.ForEach(d => Debug.WriteLine($"{d.DefinitionId} {d.Term} {d.TermDefinition}")); Assert.IsTrue(defs.Count >= 3); } }
private void InitializeDatabase() { using (var db = new GlossaryEntities()) { foreach (var item in db.Glossary.ToList()) { db.Glossary.Remove(item); } db.SaveChanges(); } }
public void CreateTest() { var item = new Glossary { Term = "Term1", Definition = "Def1" }; var result = (JsonResult)controller.Create(new DataSourceRequest(), item); using (var db = new GlossaryEntities()) { var glossaryRecords = db.Glossary.ToList(); Assert.IsNotNull(glossaryRecords); Assert.AreEqual(glossaryRecords.Count, 1); Assert.AreEqual(glossaryRecords.First().Term, "Term1"); Assert.AreEqual(glossaryRecords.First().Definition, "Def1"); } }
public void UpdateTest() { using (var db = new GlossaryEntities()) { db.Glossary.Add(new Glossary { Term = "Term1", Definition = "Def1" }); db.SaveChanges(); var item = db.Glossary.First(); item.Term = "Term2"; var result = (JsonResult)controller.Update(new DataSourceRequest(), item); var item2 = db.Glossary.FirstOrDefault(q => q.Id == item.Id); Assert.IsNotNull(item2); Assert.AreEqual(item2.Term, "Term2"); } }
private void ReadInitialDefs() { using (var db = new GlossaryEntities()) { foreach (var def in GivenTerms()) { var existing = (from d in db.Definitions where d.Term == def.Term select d).FirstOrDefault(); if (existing == null) { db.Definitions.Add(new Definition { Term = def.Term, TermDefinition = def.TermDefinition }); } else { existing.TermDefinition = def.TermDefinition; } } db.SaveChanges(); } }
public void ReadTest() { using (var db = new GlossaryEntities()) { db.Glossary.Add(new Glossary { Term = "Term1", Definition = "Def1" }); db.Glossary.Add(new Glossary { Term = "Term2", Definition = "Def2" }); db.SaveChanges(); } var result = (JsonResult)controller.Read(new DataSourceRequest()); Assert.IsNotNull(result); Assert.IsInstanceOfType(result.Data, typeof(DataSourceResult)); Assert.IsNotNull(result.Data); Assert.IsInstanceOfType(((DataSourceResult)result.Data).Data, typeof(IEnumerable)); Assert.IsNotNull(((DataSourceResult)result.Data).Data); Assert.AreEqual(((List <Glossary>)((DataSourceResult)result.Data).Data).Count, 2); }