public async Task TestCRUD() { // Arrange var item = new Country { Name = "United States of America", ISOCode = "USA" }; /****** INSERT *******/ // Act var insertedId = await _dataModel.InsertAsync(item).ConfigureAwait(true); // Assert var insertedItem = await _dataModel.FindAsync(insertedId).ConfigureAwait(true); Assert.AreEqual(item.Name, insertedItem.Name); Assert.AreEqual(item.ISOCode, insertedItem.ISOCode); /****** UPDATE *******/ // Act insertedItem.Name = "testName_1"; var result = await _dataModel.UpdateAsync(insertedItem).ConfigureAwait(true); // Assert item = await _dataModel.FindAsync(insertedItem.Id).ConfigureAwait(true); Assert.AreEqual(1, result); Assert.AreEqual(item.Name, "testName_1"); Assert.AreEqual(item.ISOCode, insertedItem.ISOCode); /****** DELETE *******/ // Act await _dataModel.DeleteAsync(insertedItem.Id).ConfigureAwait(true); // Assert var items = await _dataModel.FindAllAsync().ConfigureAwait(true); Assert.AreEqual(0, items.Count); }
public async Task TestCRUDWithCountriesTable() { // Arrange var countryITA = new Country { Name = "Italy", ISOCode = "ITA" }; // to get autoincrement id await _countriesDataModel.InsertAsync(countryITA); countryITA = (await _countriesDataModel.FindAllAsync()).First(); var item = new Contact { Name = "testName", Surname = "testSurname", PhoneNumber = "123124", Country = countryITA }; /****** INSERT *******/ // Act var insertedId = await _dataModel.InsertAsync(item).ConfigureAwait(true); // Assert var insertedItem = await _dataModel.FindAsync(insertedId).ConfigureAwait(true); Assert.AreEqual(item.Name, insertedItem.Name); Assert.AreEqual(item.Surname, insertedItem.Surname); Assert.AreEqual(item.PhoneNumber, insertedItem.PhoneNumber); Assert.AreEqual(item.Country, insertedItem.Country); ///****** UPDATE *******/ // Act await _countriesDataModel.InsertAsync(new Country { Name = "United States of America", ISOCode = "USA" }); var countryUSA = (await _countriesDataModel.FindAllAsync()).First(x => x.ISOCode.Equals("USA")); insertedItem.Name = "testName_1"; insertedItem.Country = countryUSA; var result = await _dataModel.UpdateAsync(insertedItem).ConfigureAwait(true); // Assert item = await _dataModel.FindAsync(insertedItem.Id).ConfigureAwait(true); Assert.AreEqual(1, result); Assert.AreEqual(item.Name, "testName_1"); Assert.AreEqual(item.Surname, insertedItem.Surname); Assert.AreEqual(item.Country, insertedItem.Country); Assert.AreEqual(item.PhoneNumber, insertedItem.PhoneNumber); /****** DELETE *******/ // Act await _dataModel.DeleteAsync(insertedItem.Id).ConfigureAwait(true); // Assert var items = await _dataModel.FindAllAsync().ConfigureAwait(true); Assert.AreEqual(0, items.Count); }