public void AddManagerShouldAddManager() { using (var context = new StoreDBContext(options)) { IManagerRepository _repo = new ManagerRepoDB(context); _repo.AddManager ( new Model.Manager { Id = 2, ManagerName = "Batman", ManagerEmail = "*****@*****.**", ManagerPasswordHash = "Pa55WordI23", ManagerPhone = "7948062079", ManagerLocId = 1 } ); } //use the context to check the state of the db directly when asserting. using (var assertContext = new StoreDBContext(options)) { var result = assertContext.Managers.FirstOrDefault(manager => manager.ManagerName == "Batman"); Assert.NotNull(result); Assert.Equal("Batman", result.ManagerName); } }