❔ Entity Framework

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!;
    }

{
        "id": 1,
        "name": "test123",
        "songs": null,
        "creator": {
            "userID": 0,
            "username": null,
            "email": null,
            "createdDate": "0001-01-01T00:00:00",
            "playLists": null
        }
    },
    {
        "id": 10,
        "name": "test123766",
        "songs": null,
        "creator": {
            "userID": 0,
            "username": null,
            "email": null,
            "createdDate": "0001-01-01T00:00:00",
            "playLists": null
        }
    },
    {
        "id": 11,
        "name": "test1qqq",
        "songs": null,
        "creator": {
            "userID": 0,
            "username": null,
            "email": null,
            "createdDate": "0001-01-01T00:00:00",
            "playLists": null
        }
    }