public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.PETAPOCO_InsertDogAge, Name = TestConstants.PETAPOCO_InsertDogName }; //Act repository.Add(dog); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, actualCount); }
public void PetaPocoRepository_Add_Inserts_Item_Into_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 { Age = TestConstants.PETAPOCO_InsertDogAge, Name = TestConstants.PETAPOCO_InsertDogName }; //Act repository.Add(dog); //Assert int newId = DataUtil.GetLastAddedRecordID(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName, "ID"); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, newId); }
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object); var dog = new Dog { Age = TestConstants.PETAPOCO_InsertDogAge, Name = TestConstants.PETAPOCO_InsertDogName }; //Act repository.Add(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.PETAPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.PETAPOCO_InsertDogName, row["Name"]); }
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.PETAPOCO_InsertDogAge, Name = TestConstants.PETAPOCO_InsertDogName }; //Act repository.Add(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.PETAPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.PETAPOCO_InsertDogName, row["Name"]); }
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object); var dog = new Dog { Age = TestConstants.PETAPOCO_InsertDogAge, Name = TestConstants.PETAPOCO_InsertDogName }; //Act repository.Add(dog); //Assert int newId = DataUtil.GetLastAddedRecordID(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName, "ID"); Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, newId); }