public WCFWebServiceJson()
 {
     SqlAccountRepository = new SqlAccountRepository(ConnectionString);
     SqlAlbumRepository = new SqlAlbumRepository(ConnectionString);
     SqlAlbumGenreRepository = new SqlAlbumGenreRepository(ConnectionString);
     SqlAlbumSongRepository = new SqlAlbumSongRepository(ConnectionString);
     SqlArtistRepository = new SqlArtistRepository(ConnectionString);
     SqlArtistAlbumRepository = new SqlArtistAlbumRepository(ConnectionString);
     SqlArtistGenreRepository = new SqlArtistGenreRepository(ConnectionString);
     SqlBusinessTypeRepository = new SqlBusinessTypeRepository(ConnectionString);
     SqlBusinessUserRepository = new SqlBusinessUserRepository(ConnectionString);
     SqlCountyCityRepository = new SqlCountyCityRepository(ConnectionString);
     SqlGenreRepository = new SqlGenreRepository(ConnectionString);
     SqlMediaAssetFormatRepository = new SqlMediaAssetFormatRepository(ConnectionString);
     SqlMediaAssetLocationRepository = new SqlMediaAssetLocationRepository(ConnectionString);
     SqlMediaAssetRepository = new SqlMediaAssetRepository(ConnectionString);
     SqlMediaAssetTypeRepository = new SqlMediaAssetTypeRepository(ConnectionString);
     SqlPlaylistRepository = new SqlPlaylistRepository(ConnectionString);
     SqlPlaylistSongRepository = new SqlPlaylistSongRepository(ConnectionString);
     SqlProtocolRepository = new SqlProtocolRepository(ConnectionString);
     SqlPurchasedSongRepository = new SqlPurchasedSongRepository(ConnectionString);
     SqlSongRepository = new SqlSongRepository(ConnectionString);
     SqlSongGenreRepository = new SqlSongGenreRepository(ConnectionString);
     SqlSongMediaAssetRepository = new SqlSongMediaAssetRepository(ConnectionString);
     SqlUserRepository = new SqlUserRepository(ConnectionString);
     SqlUserPlaylistRepository = new SqlUserPlaylistRepository(ConnectionString);
 }
        private List<Album> GetArtistAlbumCollection(int userId)
        {
            var artistAlbumRepository = new SqlArtistAlbumRepository(ConnectionString);
            var albumRepository = new SqlAlbumRepository(ConnectionString);

            var userAlbums = artistAlbumRepository.GetArtistAlbumsByArtistId(userId);
            var albums = userAlbums.Select(userAlbum => albumRepository.Album.FirstOrDefault(x => x.AlbumId == userAlbum.AlbumId)).ToList();

            return albums;
        }