public void RemovesBrandCorrect() { using (var dataWarehouseContext = new EFDataWarehouseContext()) { using (var transaction = dataWarehouseContext.Database.BeginTransaction()) { var brand = new Brand { Name = "KIA" }; dataWarehouseContext.Set <Brand>().Add(brand); dataWarehouseContext.SaveChanges(); Assert.IsNotNull(dataWarehouseContext.Entry(brand)); dataWarehouseContext.Set <Brand>().Remove(brand); dataWarehouseContext.SaveChanges(); Assert.IsNull(dataWarehouseContext.Set <Brand>() .FirstOrDefault(b => b.Id == brand.Id)); transaction.Rollback(); } } }
public void UpdatesBrandCorrect() { using (var dataWarehouseContext = new EFDataWarehouseContext()) { using (var transaction = dataWarehouseContext.Database.BeginTransaction()) { var brand = new Brand { Name = "KIA" }; dataWarehouseContext.Set <Brand>().Add(brand); dataWarehouseContext.SaveChanges(); Assert.IsNotNull(dataWarehouseContext.Entry(brand)); var expectedResult = brand.Name = "Toyota"; dataWarehouseContext.Entry(brand).State = EntityState.Modified; dataWarehouseContext.SaveChanges(); Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(brand).Entity.Name); transaction.Rollback(); } } }
public void UpdatesModelCorrect() { using (var dataWarehouseContext = new EFDataWarehouseContext()) { using (var transaction = dataWarehouseContext.Database.BeginTransaction()) { var brand = new Brand { Name = "KIA" }; dataWarehouseContext.Set <Brand>().Add(brand); dataWarehouseContext.SaveChanges(); var model = new Model { Name = "Rio", Brand = brand }; dataWarehouseContext.Set <Model>().Add(model); dataWarehouseContext.SaveChanges(); Assert.IsNotNull(dataWarehouseContext.Entry(model)); var expectedResult = model.Name = "Sportage"; dataWarehouseContext.Entry(model).State = EntityState.Modified; dataWarehouseContext.SaveChanges(); Assert.AreEqual(expectedResult, dataWarehouseContext.Entry(model).Entity.Name); transaction.Rollback(); } } }
public void CreatesNewModelCorrect() { using (var dataWarehouseContext = new EFDataWarehouseContext()) { using (var transaction = dataWarehouseContext.Database.BeginTransaction()) { var brand = new Brand { Name = "KIA" }; dataWarehouseContext.Set <Brand>().Add(brand); dataWarehouseContext.SaveChanges(); var model = new Model { Name = "Rio", Brand = brand }; dataWarehouseContext.Set <Model>().Add(model); dataWarehouseContext.SaveChanges(); Assert.IsNotNull(dataWarehouseContext.Entry(model)); transaction.Rollback(); } } }
public void CheckDistanceBtwMoscowAndSamara() { using (var dataWarehouseContext = new EFDataWarehouseContext()) { // Arrange. const int realDistance = 854; var mileageService = new MileageCalculatingService(); // Act. var calcDistance = mileageService.GetMileage("Москва", "Самара"); // Assert. Assert.AreEqual(realDistance, calcDistance); } }
public void EmployeeRepositoryRemovesEmployeeCorrect() { // Arrange. var dataWarehouseContext = new EFDataWarehouseContext(); EmployeeRepository employeeRepository = new EmployeeRepository(dataWarehouseContext); // Act. var newEmployee = employeeRepository.Find(emp => (emp.Firstname == "Егор")).FirstOrDefault(); if (newEmployee != null) { int id = newEmployee.Id; employeeRepository.Delete(id); employeeRepository.Commit(); } newEmployee = employeeRepository.Find(emp => (emp.Firstname == "Егор")).FirstOrDefault(); // Assert. Assert.AreEqual(null, newEmployee); }