wp-how-to-use-petapoco-with-umbraco-02.cs

[TableName("Movies")]
[PrimaryKey("Id", autoIncrement = true)]
[ExplicitColumns]
public class Movie
{
    [Column("Id")]
    [PrimaryKeyColumn(AutoIncrement = true)]
    public int Id { get; set; }

    [Column("Title")]
    public string Title { get; set; }

    [Column("DirectorId")]
    [ForeignKey(typeof(Director), Name = "FK_Movie_DirectorId")]
    public int DirectorId { get; set; }

    [ResultColumn]
    public Director Director { get; set; }

    [ResultColumn]
    public List<Actor> Actors { get; set; }
}