public void EfContext_can_CRUD_KaffeeMaschinenTyp() { var testMaschine = new KaffeeMaschinenTyp() { Modell = $"X7_{Guid.NewGuid()}", Hersteller = $"Mura {Guid.NewGuid().ToString().Substring(0, 20)}" }; string newModell = $"X8_{Guid.NewGuid()}"; using (var con = new EfContext()) { //CREATE con.KaffeeMaschinenTypen.Add(testMaschine); con.SaveChanges(); } using (var con = new EfContext()) { //READ var loaded = con.KaffeeMaschinenTypen.Find(testMaschine.Id); Assert.IsNotNull(loaded); Assert.AreEqual(testMaschine.Modell, loaded.Modell); Assert.AreEqual(testMaschine.Hersteller, loaded.Hersteller); //UPDATE loaded.Modell = newModell; con.SaveChanges(); } using (var con = new EfContext()) { //UPDATE check var loaded = con.KaffeeMaschinenTypen.Find(testMaschine.Id); Assert.AreEqual(newModell, loaded.Modell); //DELETE con.KaffeeMaschinenTypen.Remove(loaded); con.SaveChanges(); } using (var con = new EfContext()) { //UPDATE check var loaded = con.KaffeeMaschinenTypen.Find(testMaschine.Id); Assert.IsNull(loaded); } }
public void CreateDemodaten() { var m1 = new KaffeeMaschinenTyp() { Hersteller = "Bura", Modell = "Z9" }; var m2 = new KaffeeMaschinenTyp() { Hersteller = "Benseo", Modell = "Padsiff 2000" }; var m3 = new KaffeeMaschinenTyp() { Hersteller = "Baeco", Modell = "PowerDeluxe" }; var r1 = new Rezept() { Name = "Kaffee Crema", KaffeeMenge = 180, BohnenArt = BohnenArt.Crema }; var r2 = new Rezept() { Name = "Kaffee Normal", KaffeeMenge = 180, BohnenArt = BohnenArt.Cafe }; var r3 = new Rezept() { Name = "Cappuccino", KaffeeMenge = 50, BohnenArt = BohnenArt.Espresso, MilchArt = MilchArt.Schaum, MilchMenge = 150 }; var r4 = new Rezept() { Name = "Espresso", KaffeeMenge = 50, BohnenArt = BohnenArt.Espresso }; var r5 = new Rezept() { Name = "Ristretto", KaffeeMenge = 30, BohnenArt = BohnenArt.Espresso }; var r6 = new Rezept() { Name = "Ladde", KaffeeMenge = 30, BohnenArt = BohnenArt.Cafe, MilchArt = MilchArt.Sahnig, MilchMenge = 150 }; new[] { r1, r2, r3, r4, r5, r6 }.ToList().ForEach(x => m1.Rezepte.Add(x)); new[] { r1, r2, r4, r5, }.ToList().ForEach(x => m2.Rezepte.Add(x)); new[] { r1, r3, r4, r5, }.ToList().ForEach(x => m3.Rezepte.Add(x)); new[] { m1, m2, m3 }.ToList().ForEach(x => UnitOfWork.GetRepo <KaffeeMaschinenTyp>().Add(x)); UnitOfWork.Save(); }