Combining predicate and One-to-many relations

[jorismathijssen]

Is there a way to combine predicates and one-to-many relations?

I got a table with a foreign key reference. I can get the table with GetAsync and map the relations.

But i don't want to get the initial row by primary key but by a reference field. I can use SelectAsync and a predicate to get this row by the reference field.

[henkmollema]

@jorismathijssen this should be supported in the latest version, e.g.:

var products = con.Select<Product, Category, ProductOption, Product>(x => x.Name.StartsWith("Bike"));