public void ShouldGetCreativeTeamById()
        {
            var creativeteam = new CreativeTeam
            {
                About            = "",
                Email            = "*****@*****.**",
                Genre            = "rock/hardcore/post-punk",
                Name             = "dicklovers",
                Password         = "******",
                Rating           = 3.2,
                SubscribersCount = 0
            };
            var photo = new File
            {
                Bytes         = new byte[] { 0, 1, 2, 3, 4, 5, 6, 7 },
                FileExtension = ".jpeg",
                Filename      = "dicklovers.jpeg"
            };

            var creativeteamrepository = new CreativeTeamRepository(_connectionString);
            var newcreativetem         = creativeteamrepository.CreateCreativeTeam(creativeteam, photo.Bytes, photo.Filename);

            _tempCreativeteam.Add(newcreativetem.Id);

            var result = creativeteamrepository.GetCreativeTeamById(newcreativetem.Id);

            Assert.AreEqual(newcreativetem.Name, result.Name);
        }