public void ShouldAddGetDeleteReference()
        {
            //arrange
            var reference = new Reference
            {
                CommentId = Guid.Parse("6a4121a7-2b12-41e6-a408-8b13ef7d0b53") /*Guid.NewGuid()*/,
                UserId    = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23")/*Guid.NewGuid()*/
            };
            //act
            var dataLayer    = new DataLayer.Sql.DataLayer(_connectionString);
            var addReference = dataLayer.AddReference(reference);
            var dataLayer1   = new DataLayer.Sql.DataLayer(_connectionString);
            var getReference = dataLayer1.GetReference(addReference.ReferenceId);
            var dataLayer2   = new DataLayer.Sql.DataLayer(_connectionString);
            int isDeleted    = dataLayer2.DeleteReference(getReference.ReferenceId);

            //asserts
            Assert.AreEqual(addReference.ReferenceId, getReference.ReferenceId);
            Assert.AreEqual(addReference.CommentId, getReference.CommentId);
            Assert.AreEqual(addReference.UserId, getReference.UserId);
            Assert.IsNotNull(isDeleted);
        }