public void ShouldGetSubscriptions()
        {
            //arrange
            var user              = GenerateUser();
            var userSubscription  = GenerateUser();
            var userSubscription2 = GenerateUser();

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

            dataLayer.AddUser(user);
            dataLayer.AddUser(userSubscription);
            dataLayer.AddUser(userSubscription2);

            dataLayer.AddSubscription(user, userSubscription);
            dataLayer.AddSubscription(user, userSubscription2);

            user.Subscriptions = dataLayer.GetSubscription(user);
            var trueSubscription = true;

            foreach (var subscription in user.Subscriptions)
            {
                if (!dataLayer.HaveSubscription(user, subscription))
                {
                    trueSubscription = false;
                }
            }

            //assert
            Assert.AreEqual(trueSubscription, true);
        }