public List<PlaylistDTO> GetAllPlaylists()
        { 
            using (var db = new SurroundDbContext())
            {
                return db.Playlists.Include(p => p.Creator).ToList();
            }
        }


public class PlaylistDTO
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; } = null!;
        public ICollection<SongDTO> Songs { get; set; } = null!;
        [ForeignKey("UserId")]
        public int CreatorId { get; set; }
        public UserDTO Creator { get; set; } = null!;
    }

public class UserDTO
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int UserID { get; set; }
        public string? Username { get; set; }
        public string? Email { get; set; }
        public string? Password { get; set; }
        public string? VerPass;
        public DateTime CreatedDate { get; set; }
        public ICollection<PlaylistDTO> PlayLists { get; set; } = null!;
    }

public List<PlaylistDTO> GetAllPlaylists()
        { 
            using (var db = new SurroundDbContext())
            {
                return db.Playlists.Include(p => p.Creator).ToList();
            }
        }


public class PlaylistDTO
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; } = null!;
        public ICollection<SongDTO> Songs { get; set; } = null!;
        [ForeignKey("UserId")]
        public int CreatorId { get; set; }
        public UserDTO Creator { get; set; } = null!;
    }

public class UserDTO
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int UserID { get; set; }
        public string? Username { get; set; }
        public string? Email { get; set; }
        public string? Password { get; set; }
        public string? VerPass;
        public DateTime CreatedDate { get; set; }
        public ICollection<PlaylistDTO> PlayLists { get; set; } = null!;
    }