public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_InvalidDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID_Using_FluentMapper() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new FluentMapper <Dog>(string.Empty); mapper.TableName(Constants.PETAPOCO_DogTableName); mapper.PrimaryKey("ID"); mapper.Property(d => d.ID, "ID"); mapper.Property(d => d.Age, "Age"); mapper.Property(d => d.Name, "Name"); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_InvalidDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName, }; // Act repository.Delete(dog); // Assert // Assert int actualCount = DataUtil.GetRecordCount( Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(string.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName, }; // Act repository.Delete(dog); // Assert int actualCount = DataUtil.GetRecordCount( Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount); }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID_Using_FluentMapper() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new FluentMapper <Dog>(string.Empty); mapper.TableName(Constants.PETAPOCO_DogTableName); mapper.PrimaryKey("ID"); mapper.Property(d => d.ID, "ID"); mapper.Property(d => d.Age, "Age"); mapper.Property(d => d.Name, "Name"); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName, }; // Act repository.Delete(dog); // Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.PETAPOCO_InvalidDogId, Age = TestConstants.PETAPOCO_DeleteDogAge, Name = TestConstants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.PETAPOCO_DeleteDogId, Age = TestConstants.PETAPOCO_DeleteDogAge, Name = TestConstants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row["ID"] == TestConstants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Delete_Overload_Deletes_Item_From_DataBase() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act repository.Delete("WHERE ID = @0", Constants.PETAPOCO_DeleteDogId); //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount); }
public void PetaPocoRepository_Delete_Overload_Does_Nothing_With_Invalid_ID() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(string.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); // Act repository.Delete("WHERE ID = @0", Constants.PETAPOCO_InvalidDogId); // Assert int actualCount = DataUtil.GetRecordCount( Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Overload_Does_Nothing_With_Invalid_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act repository.Delete("WHERE ID = @0", Constants.PETAPOCO_InvalidDogId); //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Overload_Deletes_Item_From_DataBase_With_Correct_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(db, mapper); //Act repository.Delete("WHERE ID = @0", Constants.PETAPOCO_DeleteDogId); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert int actualCount = DataUtil.GetRecordCount(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount - 1, actualCount); }
public void PetaPocoRepository_Delete_Does_Nothing_With_Invalid_ID() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.PETAPOCO_InvalidDogId, Age = TestConstants.PETAPOCO_DeleteDogAge, Name = TestConstants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount, actualCount); }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.PETAPOCO_DeleteDogId, Age = TestConstants.PETAPOCO_DeleteDogAge, Name = TestConstants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row["ID"] == TestConstants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object); var dog = new Dog { ID = TestConstants.PETAPOCO_DeleteDogId, Age = TestConstants.PETAPOCO_DeleteDogAge, Name = TestConstants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount - 1, actualCount); }