public void ShouldDeletePhoto()
        {
            //arrange
            var user = GenerateUser();

            //act
            var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql);

            dataLayer.AddUser(user);
            var photo = GeneratePhoto(user.Id);

            dataLayer.AddPhoto(photo);
            dataLayer.DeletePhoto(photo.Id);

            var resPhoto = dataLayer.GetPhoto(photo.Id);

            //assert
            Assert.AreNotEqual(resPhoto.Id, photo.Id);
        }