I'm trying to create two database tables using migrations and NotificationHandlers.

The tables are supposed to have a one-to-many relationship. The DTO:s look like this. I've tried a few different options but I can't get anything to work:

[TableName("Seasons")]
[PrimaryKey("Id", AutoIncrement = true)]
[ExplicitColumns]
public class SeasonsSchema
{
    [PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
    [Column("Id")]
    public int Id { get; set; }

    [Column("SeasonPageId")]
    public int SeasonPageId { get; set; }

    [Reference(ReferenceType.Many, ColumnName = "TournamentsId", ReferenceMemberName = "TournamentsId")]
    public List<TournamentsSchema> Tournaments { get; set; }
}

and

[TableName("Tournaments")]
[PrimaryKey("Id", AutoIncrement = true)]
[ExplicitColumns]
public class TournamentsSchema
{
    [PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
    [Column("Id")]
    public int Id { get; set; }

    [Column("TournamentPageId")]
    public int TournamentPageId { get; set; }
}

this is the error thats thrown when starting the application

If I remove the

 [Reference(ReferenceType.Many, ColumnName = "TournamentsId", ReferenceMemberName = "TournamentsId")]
    public List<TournamentsSchema> Tournaments { get; set; }

from the SeasonsSchema class it obviously work and both tables are created as they should, but there are no relationship between the two tables.

I'm missing something I'm sure but I can't think of anything to try right now.

I tried removing the Reference attribute and I've tried a bunch of things to get this to work but nothing have this far.