public void TestLocationLineRemoval() { var options = new DbContextOptionsBuilder <P0_DbContext>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; using (var context = new P0_DbContext(options)) { context.Remove(context.locationLines.SingleOrDefault(x => x.LocationLineId == 1)); context.SaveChanges(); } using (var context = new P0_DbContext(options)) { Assert.Null(context.locationLines.SingleOrDefault(x => x.LocationId == 1)); } }
public void TestOrderRemoval() { var options = new DbContextOptionsBuilder <P0_DbContext>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; using (var context = new P0_DbContext(options)) { context.Add(new Order(1, 1, DateTime.Now, 1)); context.SaveChanges(); context.Remove(context.orders.SingleOrDefault(x => x.OrderId == 1)); context.SaveChanges(); } using (var context = new P0_DbContext(options)) { Assert.Null(context.orders.SingleOrDefault(x => x.OrderId == 1)); } }
public void TestCustomerRemoval() { var options = new DbContextOptionsBuilder <P0_DbContext>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; using (var context = new P0_DbContext(options)) { context.Add(new Customer("Test", "Best")); context.SaveChanges(); context.Remove(context.customers.SingleOrDefault(x => x.FirstName == "Test")); context.SaveChanges(); } using (var context = new P0_DbContext(options)) { Assert.Null(context.customers.SingleOrDefault(x => x.FirstName == "Test")); } }