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

var sql = new Sql()
    .Select<Movie>(dbContext.SqlSyntax)
    .AndSelect<Director>(dbContext.SqlSyntax)
    .From<Movie>(dbContext.SqlSyntax)
    .InnerJoin<Director>(dbContext.SqlSyntax)
    .On<Movie, Director>(dbContext.SqlSyntax, m => m.DirectorId, d => d.Id);