public void Should_update_entity_in_single_context() { try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var toUpdate = repo.GetById(10337); // alter property and then update -- Act toUpdate.ShipName = "abc"; repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var original = repo.GetById(10337); Assert.AreEqual("abc", original.ShipName); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipName(); } }
public void Should_insert_new_record_and_populate_Id() { var orderDate = DateTime.Now.AddDays(-20); var requiredDate = DateTime.Now.AddDays(-10); var shippedDate = DateTime.Now.AddDays(-15); var newOrder = new Order { CustomerID = "ABCDE", EmployeeID = 5, Freight = 12.13m, OrderDate = orderDate, RequiredDate = requiredDate, ShipName = "My Stuff", ShipAddress = "P.O. Box 123", ShipCity = "London", ShipPostalCode = "EC1 4RT", ShipCountry = "UK", ShipVia = 3, ShippedDate = shippedDate }; using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); repo.Insert(newOrder); } Assert.AreEqual(10348, newOrder.OrderID); }
public void Should_update_entity_in_single_context() { try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var toUpdate = repo.GetById(10337); // alter property and then update -- Act toUpdate.ShipName = "abc"; repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var original = repo.GetById(10337); Assert.AreEqual("abc", original.ShipName); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipName(); } }
public void Should_insert_new_record_and_populate_Id() { var orderDate = DateTime.Now.AddDays(-20); var requiredDate = DateTime.Now.AddDays(-10); var shippedDate = DateTime.Now.AddDays(-15); var newOrder = new Order { CustomerID = "ABCDE", EmployeeID = 5, Freight = 12.13m, OrderDate = orderDate, RequiredDate = requiredDate, ShipName = "My Stuff", ShipAddress = "P.O. Box 123", ShipCity = "London", ShipPostalCode = "EC1 4RT", ShipCountry = "UK", ShipVia = 3, ShippedDate = shippedDate }; using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); repo.Insert(newOrder); } Assert.AreEqual(10348, newOrder.OrderID); }
public void Should_throw_ArgumentNullException_if_null_passed_in() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.Throws<ArgumentNullException>(() => repo.Delete(null)); } }
public void Should_throw_ArgumentNullException_if_null_passed_in() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.Throws <ArgumentNullException>(() => repo.Delete(null)); } }
public void Should_return_an_object_for_id_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.IsNotNull(repo.GetById(10248)); } }
public void Should_return_empty_enumerable_where_no_records_match_criteria() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); CollectionAssert.IsEmpty(repo.Find(o => o.CustomerID == "NoMatch")); } }
public void Should_return_correct_number_of_records_based_on_criteria() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.AreEqual(3, repo.Find(o => o.CustomerID == "VINET").Count()); } }
public void Should_throw_InvalidOperationException_if_invalid_id_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.Throws <InvalidOperationException>(() => repo.GetById(1)); } }
public void Should_correct_number_of_records() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.AreEqual(100, repo.GetAll().Count()); } }
public void Should_return_empty_enumerable_where_no_records_match_criteria() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); CollectionAssert.IsEmpty(repo.Find(o => o.CustomerID == "NoMatch")); } }
public void Should_return_correct_number_of_records_based_on_criteria() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.AreEqual(3, repo.Find(o => o.CustomerID == "VINET").Count()); } }
public void Should_throw_exception_if_null_criteria_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.Throws<ArgumentNullException>(() => repo.Find(null)); } }
public void Should_throw_InvalidOperationException_if_invalid_id_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.Throws<InvalidOperationException>(() => repo.GetById(1)); } }
public void Should_return_an_object_for_id_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.IsNotNull(repo.GetById(10248)); } }
public void Should_throw_ArgumentNullException_if_null_entity_provided() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); Assert.Throws <ArgumentNullException>(() => repo.Insert(null)); } }
public void Should_return_a_enumerable_with_records() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); CollectionAssert.IsNotEmpty(repo.GetAll()); } }
public void Should_correct_number_of_records() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); Assert.AreEqual(100, repo.GetAll().Count()); } }
public void Should_return_a_enumerable_with_records() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); CollectionAssert.IsNotEmpty(repo.GetAll()); } }
public void Should_throw_ArgumentNullException_if_null_id_provided() { using (var context = new RepositoryTestDataContext()) { using (var repo = new Repository<Order>(context)) { Assert.Throws<ArgumentNullException>(() => repo.GetById(null)); } } }
public void Should_return_correct_object_for_id() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var actual = repo.GetById(10248); actual.Satisfies(o => o.OrderID == 10248 && o.ShipVia == 3 && o.ShipName == "Vins et alcools Chevalier"); } }
public void Should_return_correct_object_for_id() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var actual = repo.GetById(10248); actual.Satisfies(o => o.OrderID == 10248 && o.ShipVia == 3 && o.ShipName == "Vins et alcools Chevalier"); } }
public void Should_delete_the_record_when_given_a_valid_entity_on_the_same_data_context() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var original = repo.GetById(10287); repo.Delete(original); } Assert.IsTrue(CheckRecordDeleted()); TestScriptHelper.InsertDeletedRecord(); }
public void Should_delete_the_record_when_given_a_valid_entity_on_the_same_data_context() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var original = repo.GetById(10287); repo.Delete(original); } Assert.IsTrue(CheckRecordDeleted()); TestScriptHelper.InsertDeletedRecord(); }
public void Should_have_correct_first_and_last_item() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var items = repo.GetAll(); items.First().Satisfies(o => o.OrderID == 10248 && o.ShipVia == 3 && o.ShipName == "Vins et alcools Chevalier"); items.Last().Satisfies(o => o.OrderID == 10347 && o.ShipVia == 3 && o.ShipName == "Familia Arquibaldo"); } }
private bool CheckRecordDeleted() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); try { repo.GetById(10287); } catch (InvalidOperationException ioe) { return true; } return false; } }
public void Should_have_correct_first_and_last_item() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var items = repo.GetAll(); items.First().Satisfies(o => o.OrderID == 10248 && o.ShipVia == 3 && o.ShipName == "Vins et alcools Chevalier"); items.Last().Satisfies(o => o.OrderID == 10347 && o.ShipVia == 3 && o.ShipName == "Familia Arquibaldo"); } }
private bool CheckRecordDeleted() { using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); try { repo.GetById(10287); } catch (InvalidOperationException ioe) { return(true); } return(false); } }
public void Should_update_field_to_null() { Order toUpdate = null; try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); toUpdate = repo.GetById(10337); } // alter property and then update -- Act toUpdate.ShipName = null; using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var original = repo.GetById(10337); Assert.IsNull(original.ShipName); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipName(); } }
public void Should_update_null_property_to_given_value() { Order toUpdate = null; try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); toUpdate = repo.GetById(10337); } toUpdate.ShipRegion = "West"; using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); var original = repo.GetById(10337); Assert.AreEqual("West", original.ShipRegion); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipRegion(); } }
public void Should_insert_record_with_nulls_where_appropriate() { var orderDate = DateTime.Now.AddDays(-20); var requiredDate = DateTime.Now.AddDays(-10); var shippedDate = DateTime.Now.AddDays(-15); var newOrder = new Order { CustomerID = "ABCDE", Freight = 12.13m, OrderDate = orderDate, RequiredDate = requiredDate, ShipName = "My Stuff", ShipAddress = "P.O. Box 123", ShipCity = "London", ShipPostalCode = "EC1 4RT", ShipCountry = "UK", ShipVia = 3, ShippedDate = shippedDate }; using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); repo.Insert(newOrder); } Order inserted = null; using (var context = new RepositoryTestDataContext()) { var repo = new Repository <Order>(context); inserted = repo.GetById(newOrder.OrderID); } Assert.IsNull(inserted.EmployeeID); Assert.IsNull(inserted.ShipRegion); }
public void Should_insert_record_with_nulls_where_appropriate() { var orderDate = DateTime.Now.AddDays(-20); var requiredDate = DateTime.Now.AddDays(-10); var shippedDate = DateTime.Now.AddDays(-15); var newOrder = new Order { CustomerID = "ABCDE", Freight = 12.13m, OrderDate = orderDate, RequiredDate = requiredDate, ShipName = "My Stuff", ShipAddress = "P.O. Box 123", ShipCity = "London", ShipPostalCode = "EC1 4RT", ShipCountry = "UK", ShipVia = 3, ShippedDate = shippedDate }; using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); repo.Insert(newOrder); } Order inserted = null; using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); inserted = repo.GetById(newOrder.OrderID); } Assert.IsNull(inserted.EmployeeID); Assert.IsNull(inserted.ShipRegion); }
public void Should_update_null_property_to_given_value() { Order toUpdate = null; try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); toUpdate = repo.GetById(10337); } toUpdate.ShipRegion = "West"; using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var original = repo.GetById(10337); Assert.AreEqual("West", original.ShipRegion); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipRegion(); } }
public void Should_update_field_to_null() { Order toUpdate = null; try { // Get original -- Arrange using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); toUpdate = repo.GetById(10337); } // alter property and then update -- Act toUpdate.ShipName = null; using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); repo.Update(toUpdate); } // Requery db to Assert that data updated using (var context = new RepositoryTestDataContext()) { var repo = new Repository<Order>(context); var original = repo.GetById(10337); Assert.IsNull(original.ShipName); } } finally { // Clean up the data so that its in the correct state TestScriptHelper.ResetShipName(); } }