public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID()
        {
            // 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
            {
                Age  = Constants.PETAPOCO_InsertDogAge,
                Name = Constants.PETAPOCO_InsertDogName,
            };

            // Act
            repository.Insert(dog);

            // Assert
            int newId = DataUtil.GetLastAddedRecordID(
                Constants.PETAPOCO_DatabaseName,
                Constants.PETAPOCO_DogTableName, Constants.TABLENAME_Key);

            Assert.AreEqual(Constants.PETAPOCO_RecordCount + 1, newId);
        }