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

var sql = new Sql()
    .Select("*")
    .From<Director>(dbContext.SqlSyntax)
    .Where<Director>(d => d.FirstName == "James", dbContext.SqlSyntax); ;
var james = dbContext.Database.Fetch<Actor>(sql);